

In [1]:

    
# This changes the current directory to the base saga directory - make sure to run this first!
# This is necessary to be able to import the py files and use the right directories,
# while keeping all the notebooks in their own directory.

import os
import sys
import collections
from StringIO import StringIO

if 'saga_base_dir' not in locals():
    saga_base_dir = os.path.abspath('..')
if saga_base_dir not in sys.path:
    os.chdir(saga_base_dir)
    
import targeting



In [2]:

    
from __future__ import print_function, division

import numpy as np

from astropy import units as u
from astropy import table
from astropy.coordinates import SkyCoord
from astropy.visualization import hist as ahist



In [3]:

    
%matplotlib inline
from matplotlib import pyplot as plt
from matplotlib import style
from mpl_toolkits.mplot3d import Axes3D

plt.rcParams['image.cmap'] = 'viridis'
plt.rcParams['image.origin'] = 'lower'
plt.rcParams['axes.prop_cycle'] = style.library['seaborn-deep']['axes.prop_cycle']
plt.rcParams['figure.figsize'] = (14, 8)
plt.rcParams['axes.titlesize'] =  plt.rcParams['axes.labelsize'] = 16
plt.rcParams['xtick.labelsize'] =  plt.rcParams['ytick.labelsize'] = 14

This notebook investigates objects that were not sucessful redshifts that are bright (r<18).

The objects from Marla



In [7]:

    
#Objects brighter than 18 that pass gri but don't have spectra

bright_tab_str = """
      ZQUALITY   RA  DEC
                     1       354.14926      0.32713565
                    -1       353.99294     0.086364837
                     2       354.08257     0.060601196
                     1       247.64421       19.958888
                     1       335.94415      -3.4297140
                     1       335.97281      -3.4295662
                     2       335.82694      -3.6492167
                     1       335.80925      -3.0283747
                     1       354.14926      0.32713565
                    -1       353.99294     0.086364837
                     2       354.08257     0.060601196
                    -1       234.33588       16.249183
                     1       234.33322       16.248215
                     2       233.63394       16.559677
                     1       233.63396       16.556191
                     1       233.60915       16.528896
                     1       233.97446       16.038832
                     1       123.26675       36.256392
                    -1       122.98465       35.862910
                    -1       123.26544       36.232026
                     1       123.26814       36.244014
                     1       123.48530       36.192051
                     1       221.50404     -0.24056759
                     1       221.58943     -0.24814454
                    -1       221.51179     -0.21110648
                     1       221.58127     -0.22449246
                     1       221.49195     -0.24697855
                     1       221.89004     -0.25072021
                     2       39.574015      -1.3493834
                     1       39.777895      -1.5543484
"""[1:-1]
bright_tab = table.Table.read(bright_tab_str, format='ascii')

the links below allow exploring of individual objects



In [31]:

    
url_templ = 'http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra={}&dec={}'

for i, row in enumerate(bright_tab):
    url = url_templ.format(row['RA'], row['DEC'])
    print(i, url)









    



0 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=354.14926&dec=0.32713565
1 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=353.99294&dec=0.086364837
2 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=354.08257&dec=0.060601196
3 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=247.64421&dec=19.958888
4 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=335.94415&dec=-3.429714
5 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=335.97281&dec=-3.4295662
6 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=335.82694&dec=-3.6492167
7 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=335.80925&dec=-3.0283747
8 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=354.14926&dec=0.32713565
9 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=353.99294&dec=0.086364837
10 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=354.08257&dec=0.060601196
11 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=234.33588&dec=16.249183
12 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=234.33322&dec=16.248215
13 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=233.63394&dec=16.559677
14 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=233.63396&dec=16.556191
15 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=233.60915&dec=16.528896
16 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=233.97446&dec=16.038832
17 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=123.26675&dec=36.256392
18 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=122.98465&dec=35.86291
19 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=123.26544&dec=36.232026
20 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=123.26814&dec=36.244014
21 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=123.4853&dec=36.192051
22 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.50404&dec=-0.24056759
23 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.58943&dec=-0.24814454
24 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.51179&dec=-0.21110648
25 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.58127&dec=-0.22449246
26 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.49195&dec=-0.24697855
27 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=221.89004&dec=-0.25072021
28 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=39.574015&dec=-1.3493834
29 http://skyserver.sdss.org/dr13/en/tools/explore/Summary.aspx?ra=39.777895&dec=-1.5543484

Visual inspection reveals the vast majority are "fake" objects

Cross-match with SAGA base catalogs



In [119]:

    
saga_spectra = table.Table.read('SAGADropbox/data/saga_spectra_dirty.fits.gz')



In [124]:

    
scbright = SkyCoord(bright_tab['RA'], bright_tab['DEC'], unit=u.deg)
scdirty = SkyCoord(saga_spectra['RA'], saga_spectra['DEC'], unit=u.deg)

idx, d2d, _ = scbright.match_to_catalog_sky(scdirty)
saga_spectra_matches = saga_spectra[idx[d2d<1*u.arcsec]]
saga_spectra_matches









    Out[124]:




<Table masked=True length=24>

OBJID RA DEC PHOTPTYPE PHOT_SG FLAGS clean SATURATED BAD_COUNTS_ERROR BINNED1 TOO_FEW_GOOD_DETECTIONS u g r i z u_err g_err r_err i_err z_err MODELMAGERR_U MODELMAGERR_G MODELMAGERR_R MODELMAGERR_I MODELMAGERR_Z EXTINCTION_U EXTINCTION_G EXTINCTION_R EXTINCTION_I EXTINCTION_Z DERED_U DERED_G DERED_R DERED_I DERED_Z PETRORAD_U PETRORAD_G PETRORAD_R PETRORAD_I PETRORAD_Z PETRORADERR_U PETRORADERR_G PETRORADERR_R PETRORADERR_I PETRORADERR_Z DEVRAD_U DEVRADERR_U DEVRAD_G DEVRADERR_G DEVRAD_R DEVRADERR_R DEVRAD_I DEVRADERR_I DEVRAD_Z DEVRADERR_Z DEVAB_U DEVAB_G DEVAB_R DEVAB_I DEVAB_Z CMODELMAG_U CMODELMAGERR_U CMODELMAG_G CMODELMAGERR_G CMODELMAG_R CMODELMAGERR_R CMODELMAG_I CMODELMAGERR_I CMODELMAG_Z CMODELMAGERR_Z PSFMAG_U PSFMAGERR_U PSFMAG_G PSFMAGERR_G PSFMAG_R PSFMAGERR_R PSFMAG_I PSFMAGERR_I PSFMAG_Z PSFMAGERR_Z FIBERMAG_U FIBERMAGERR_U FIBERMAG_G FIBERMAGERR_G FIBERMAG_R FIBERMAGERR_R FIBERMAG_I FIBERMAGERR_I FIBERMAG_Z FIBERMAGERR_Z FRACDEV_U FRACDEV_G FRACDEV_R FRACDEV_I FRACDEV_Z Q_U U_U Q_G U_G Q_R U_R Q_I U_I Q_Z U_Z EXPAB_U EXPRAD_U EXPPHI_U EXPAB_G EXPRAD_G EXPPHI_G EXPAB_R EXPRAD_R EXPPHI_R EXPAB_I EXPRAD_I EXPPHI_I EXPAB_Z EXPRAD_Z EXPPHI_Z FIBER2MAG_R FIBER2MAGERR_R EXPMAG_R EXPMAGERR_R PETROR50_R PETROR90_R PETROMAG_R SB_EXP_R SB_PETRO_R J JERR H HERR K KERR SPEC_Z SPEC_Z_ERR SPEC_Z_WARN PHOTOZ PHOTOZ_ERR W1 W1ERR W2 W2ERR HOST_RA HOST_DEC HOST_DIST HOST_VHOST HOST_MK HOST_NSAID HOST_FLAG HOST_SAGA_NAME RHOST_ARCM RHOST_KPC OBJ_NSAID SATS PROBABILITY_CLASS1 RESCALED_PROBABILITY_CLASS1 REMOVE TELNAME MASKNAME ZQUALITY SPEC_CLASS SPECOBJID SPEC_REPEAT
int64 float64 float64 int16 str40 int64 int32 int64 int64 int64 int64 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float64 float64 float32 float32 float32 float32 float32 float32 float32 float32 int32 float32 float32 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64 str48 float64 float64 int64 int64 float64 float64 int64 str6 str48 int64 str2 str48 str48
1237666408439874076 354.149256048 0.327135654889 3 GALAXY 439873639153920 0 0 0 268435456 281474976710656 19.0084 17.5877 17.7556 17.5112 16.6073 0.65821 0.0625852 0.11989 0.135155 0.255732 0.65821 0.0625852 0.11989 0.135155 0.255732 0.180303 0.132665 0.0962197 0.0729605 0.0517299 18.8281 17.455 17.6594 17.4382 16.5556 2.96983 258.43 106.721 106.738 106.729 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.6688 4.67312 29.672 5.5689 15.9071 7.38759 29.6752 2.66867 29.6683 6.69654 0.786653 0.680324 0.410557 0.541301 0.649836 19.3437 0.585916 18.0701 0.0766224 19.0124 0.169918 18.396 0.122199 17.4474 0.261338 24.3827 0.969478 22.8847 0.13416 22.4667 0.220019 22.8181 0.23614 21.9866 0.442717 24.0097 1.10144 22.7494 0.159364 22.3338 0.169423 21.9554 0.180316 21.6412 0.54159 0.0 0.599746 0.827468 0.872827 0.797219 -0.749816 -0.0140499 -0.297813 0.00354002 -0.42878 -0.00197215 2.7778 -0.142986 -1.03864 0.0148926 0.151253 59.3337 118.995 0.515816 59.3542 130.038 0.392589 59.3437 119.972 0.197627 55.2108 143.544 0.195292 59.3329 166.745 22.9446 0.212571 17.7556 0.11989 41.9779 61.174 17.7052 28.6179477918 27.8157263213 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.36423 -1.0 -1 0.440122 0.180171 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 2.10045371865 21.2427834111 -1 -1 0.271041570532 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz -- 257.0 AAT
1237663784194802917 354.082573493 0.0606011959357 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 18.9742 18.065 17.821 17.0293 17.6484 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.177183 0.130369 0.0945548 0.0716981 0.0508348 18.797 17.9346 17.7265 16.9576 17.5975 166.532 166.519 2.13242 166.521 1.51506 -1000.0 -1000.0 1.98958 -1000.0 1.3726 27.7313 38.3936 29.67 3.6178 29.6636 3.84095 29.6681 4.98251 3.15931 6.56673 0.05 0.416075 0.439032 0.537075 0.0999623 20.4846 0.326491 18.4098 0.107972 18.0634 0.152897 17.5438 0.105611 20.6131 0.349476 23.6721 0.458279 23.5247 0.199858 23.9531 0.372164 22.4871 0.167451 21.7329 0.33456 23.315 0.523709 23.1555 0.22177 22.8352 0.273454 22.0672 0.200834 21.6757 0.539247 0.832777 0.363506 0.405709 0.523537 0.674803 -0.327571 0.0052023 0.728635 -0.0113849 -28.5556 -0.347043 0.652797 -0.000978889 -0.232232 -0.00282717 0.100326 30.6986 96.288 0.397939 59.3397 120.465 0.539669 59.3212 134.438 0.398894 59.3404 132.211 0.226735 0.967878 179.969 23.4733 0.310638 17.6338 0.130805 71.4389 108.246 16.9051 28.4953306615 28.1701969783 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.18022 -1.0 -1 0.019204 0.096566 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 14.4940499323 146.584077384 -1 -1 0.167829510881 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz 2 142.0 AAT
1237662698115237198 247.644214855 19.9588877603 3 GALAXY 281543964623104 1 0 0 268435456 281474976710656 29.5592 19.4326 18.0202 18.1677 18.687 0.727629 0.256526 0.105169 0.19081 1.08119 0.727629 0.256526 0.105169 0.19081 1.08119 0.301252 0.221658 0.160765 0.121903 0.0864309 29.2579 19.2109 17.8595 18.0458 18.6006 2.96985 2.96992 68.3184 1.40406 2.97063 -1000.0 -1000.0 -1000.0 0.427057 -1000.0 20.5417 49.5809 1.70815 1.60173 29.6776 2.43735 1.43811 1.17967 23.7816 8.7603 0.99966 0.05 0.454815 0.0558665 0.05 28.8244 0.616396 23.0591 0.233919 18.4891 0.120731 21.95 0.180517 19.5513 0.605208 25.2149 0.548472 23.7455 0.234155 23.0507 0.173982 22.6574 0.180495 22.5869 0.407538 24.5077 0.882473 23.6922 0.323742 22.7909 0.217689 22.6537 0.297644 22.6971 0.629931 0.0 0.445207 0.516113 0.533171 0.591065 -3.30906 0.273711 -3.36026 -0.0293676 5.22457 0.0490649 -5.26914 -0.0991799 -0.582674 0.0664846 0.608205 17.6019 114.08 0.05 1.21676 65.4806 0.472646 47.0862 203.768 0.3057 0.732101 84.6894 0.100002 30.7153 182.331 23.3543 0.234656 18.0206 0.105169 20.7253 38.5525 18.537 28.380543459 27.1150032123 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.0903 -1.0 -1 0.094972 0.067909 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 26.2161264974 261.719719068 -1 -1 0.00226478342688 -1.0 -1 AAT /Spectra/Final/AAT/Odyssey_1_MG.mz -- 220.0 AAT
1237679996084618235 335.944149612 -3.42971396292 3 GALAXY 422281453110016 1 0 0 268435456 281474976710656 19.6617 18.7984 17.8892 18.2751 27.0803 0.803183 0.15 0.103178 0.232389 1.22739 0.803183 0.15 0.103178 0.232389 1.22739 0.326095 0.239937 0.174023 0.131956 0.0935585 19.3356 18.5584 17.7152 18.1432 26.9868 106.72 2.96947 106.727 1.77452 0.769548 -1000.0 -1000.0 -1000.0 0.827213 0.349529 10.1676 14.2086 29.6611 14.0226 29.6688 4.33029 4.26997 2.86454 0.00388309 12.8824 0.05 0.05 0.36054 0.05 0.153286 21.1725 0.425337 21.2804 0.28978 18.3673 0.11821 21.2924 0.202941 21.9852 0.537469 23.189 0.55587 24.0625 0.410854 22.6889 0.173071 22.4104 0.211984 22.0028 0.521644 22.9765 0.613796 24.1745 0.520276 22.6257 0.230246 22.5804 0.349771 22.2132 0.774198 0.953862 0.0 0.531835 0.534782 1.0 -1.08025 0.394262 2.1283 -0.00546058 1.27349 -0.00447342 1.00522 0.0210215 -6.71564 0.00771856 0.137168 25.974 127.155 0.05 19.7791 90.87 0.23433 59.3476 167.943 0.05 2.19525 75.0317 0.0935701 0.00299789 66.8017 23.2302 0.259296 17.8892 0.103178 36.189 54.5524 17.9503 28.7516599284 27.7385973506 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.23193 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 1.86931518968 21.3023547728 -1 -1 0.140434915711 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz -- 319.0 AAT
1237679996084618009 335.972808358 -3.42956615144 3 GALAXY 193585182019856 1 0 0 268435456 0 20.1496 18.5759 17.9106 17.654 17.4315 0.212052 0.0265917 0.0299772 0.0605004 0.074865 0.212052 0.0265917 0.0299772 0.0605004 0.074865 0.332555 0.244691 0.17747 0.13457 0.0954121 19.8171 18.3312 17.7332 17.5194 17.3361 2.96973 9.01185 10.2006 10.1937 8.38178 -1000.0 0.521633 0.418006 0.780476 1.20792 29.67 4.4335 14.8379 1.88275 14.3611 1.75306 15.6604 2.76502 15.3494 4.9481 0.909169 0.874766 0.936407 0.699987 0.846943 19.8191 0.211485 18.6436 0.0264928 17.9106 0.0351466 17.6327 0.0887886 17.5974 0.0898144 24.3825 0.96654 21.5681 0.0551883 21.3764 0.0576317 21.1532 0.0734761 20.4846 0.195213 23.324 3.87519 21.2772 0.0474032 20.6442 0.0408292 20.3021 0.0473202 20.0416 0.12304 0.0 0.0 0.0 0.0 0.0168801 -0.384395 -0.0329883 -0.0440571 -0.00066821 -0.0164063 0.00555766 -0.00919171 0.0140592 -0.0977588 0.0366081 0.640487 8.06442 125.031 0.92585 4.64061 123.121 0.91529 5.10972 73.306 0.750006 5.61678 57.984 0.911775 4.24964 77.2666 21.4674 0.0582251 17.9106 0.0351466 4.9025 10.142 17.9394 23.4480533959 23.3868944452 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.06411 -1.0 -1 0.095793 0.039418 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 3.58429435539 40.8459206448 -1 -1 0.0301093951356 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz -- 16.0 AAT
1237680066954265472 335.826943253 -3.64921666464 3 GALAXY 422281453109504 1 0 0 268435456 281474976710656 17.963 21.9054 17.3973 16.6338 18.7629 0.324965 4.65065 0.11944 0.0997275 2.5685 0.324965 4.65065 0.11944 0.0997275 2.5685 0.33624 0.247402 0.179437 0.136061 0.0964692 17.6268 21.658 17.2179 16.4978 18.6665 2.97064 2.96987 106.732 106.691 3.31327 -1000.0 -1000.0 -1000.0 -1000.0 3.20327 29.6706 104.939 0.568656 1.47687 29.6717 3.5503 29.6596 4.15323 13.1261 15.0645 0.05 0.994876 0.998178 0.421721 0.05 17.9907 0.281465 22.9246 0.323781 17.8 0.136571 17.6995 0.106585 19.1142 0.253386 22.9003 0.496865 23.6544 0.349211 22.5795 0.195917 22.704 0.334501 21.2636 0.402959 22.7919 0.444532 23.6813 0.363085 22.741 0.26119 22.3472 0.301723 21.251 0.31298 0.0 0.0 0.424886 0.560847 1.0 -0.305215 -0.00268718 -0.654144 0.00205627 0.0110234 -0.00645435 3.60766 0.0233994 6.16861 -0.392916 0.512452 59.351 63.2067 0.83575 1.13677 131.448 0.695894 59.3365 10.8107 0.264283 54.3801 3.59802 0.111858 6.29434 121.813 23.3114 0.283817 17.3973 0.11944 41.1795 57.0415 17.6188 28.2593827041 27.687688589 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.23278 -1.0 -1 0.459457 0.114518 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 14.0333400376 159.920795731 -1 -1 0.0242416586907 -1.0 -1 AAT /Spectra/Final/AAT/OBrother2016_1_MG.mz 2 127.0 AAT
1237678879399411942 335.809245892 -3.0283746526 3 GALAXY 35253360132368 1 0 0 268435456 0 20.46 18.2557 17.5865 17.4144 20.308 0.872457 0.0526832 0.0466527 0.0591699 3.06308 0.872457 0.0526832 0.0466527 0.0591699 3.06308 0.335682 0.246991 0.179139 0.135836 0.0963091 20.1244 18.0087 17.4074 17.2786 20.2117 2.97065 2.96967 106.728 2.97036 0.562804 -1000.0 -1000.0 -1000.0 -1000.0 0.379493 29.6746 8.36016 16.5973 3.57407 29.67 2.81467 0.100151 0.098134 0.000221021 1.62263 0.387344 0.79445 0.795263 0.986523 0.171256 20.8185 0.886197 18.9018 0.0537474 17.6743 0.0475329 21.0265 0.0702893 21.91 1.05938 23.8669 1.08505 21.5643 0.252845 21.2966 0.449579 21.1434 0.581672 21.8594 0.5107 22.6916 0.319221 21.5964 0.245781 21.0996 0.55142 20.7665 0.642724 20.5281 0.142662 1.0 0.874706 0.652507 0.680091 1.0 90.7772 -1.74338 0.898356 0.0698254 0.268972 0.0146439 -0.404245 -0.179855 9.70789 -0.595481 0.348999 59.3503 42.9594 0.132612 5.34247 76.1004 0.909094 13.7618 11.8547 0.833924 0.288914 103.863 0.114784 0.0 84.6794 21.7331 0.657386 17.8614 0.0489419 24.3223 61.1869 17.3493 25.5501782186 26.2747314648 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00738 -1.0 -1 0.5823 0.075071 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 24.9831982417 284.7012087 -1 -1 0.0689165466116 -1.0 -1 AAT /Spectra/Final/AAT/OBrother2016_1_MG.mz -- 284.0 AAT
1237666408439874076 354.149256048 0.327135654889 3 GALAXY 439873639153920 0 0 0 268435456 281474976710656 19.0084 17.5877 17.7556 17.5112 16.6073 0.65821 0.0625852 0.11989 0.135155 0.255732 0.65821 0.0625852 0.11989 0.135155 0.255732 0.180303 0.132665 0.0962197 0.0729605 0.0517299 18.8281 17.455 17.6594 17.4382 16.5556 2.96983 258.43 106.721 106.738 106.729 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.6688 4.67312 29.672 5.5689 15.9071 7.38759 29.6752 2.66867 29.6683 6.69654 0.786653 0.680324 0.410557 0.541301 0.649836 19.3437 0.585916 18.0701 0.0766224 19.0124 0.169918 18.396 0.122199 17.4474 0.261338 24.3827 0.969478 22.8847 0.13416 22.4667 0.220019 22.8181 0.23614 21.9866 0.442717 24.0097 1.10144 22.7494 0.159364 22.3338 0.169423 21.9554 0.180316 21.6412 0.54159 0.0 0.599746 0.827468 0.872827 0.797219 -0.749816 -0.0140499 -0.297813 0.00354002 -0.42878 -0.00197215 2.7778 -0.142986 -1.03864 0.0148926 0.151253 59.3337 118.995 0.515816 59.3542 130.038 0.392589 59.3437 119.972 0.197627 55.2108 143.544 0.195292 59.3329 166.745 22.9446 0.212571 17.7556 0.11989 41.9779 61.174 17.7052 28.6179477918 27.8157263213 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.36423 -1.0 -1 0.440122 0.180171 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 2.10045371865 21.2427834111 -1 -1 0.271041570532 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz -- 257.0 AAT
1237663784194802917 354.082573493 0.0606011959357 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 18.9742 18.065 17.821 17.0293 17.6484 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.177183 0.130369 0.0945548 0.0716981 0.0508348 18.797 17.9346 17.7265 16.9576 17.5975 166.532 166.519 2.13242 166.521 1.51506 -1000.0 -1000.0 1.98958 -1000.0 1.3726 27.7313 38.3936 29.67 3.6178 29.6636 3.84095 29.6681 4.98251 3.15931 6.56673 0.05 0.416075 0.439032 0.537075 0.0999623 20.4846 0.326491 18.4098 0.107972 18.0634 0.152897 17.5438 0.105611 20.6131 0.349476 23.6721 0.458279 23.5247 0.199858 23.9531 0.372164 22.4871 0.167451 21.7329 0.33456 23.315 0.523709 23.1555 0.22177 22.8352 0.273454 22.0672 0.200834 21.6757 0.539247 0.832777 0.363506 0.405709 0.523537 0.674803 -0.327571 0.0052023 0.728635 -0.0113849 -28.5556 -0.347043 0.652797 -0.000978889 -0.232232 -0.00282717 0.100326 30.6986 96.288 0.397939 59.3397 120.465 0.539669 59.3212 134.438 0.398894 59.3404 132.211 0.226735 0.967878 179.969 23.4733 0.310638 17.6338 0.130805 71.4389 108.246 16.9051 28.4953306615 28.1701969783 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.18022 -1.0 -1 0.019204 0.096566 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 14.4940499323 146.584077384 -1 -1 0.167829510881 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz 2 142.0 AAT
1237665565541860447 234.33322017 16.248215191 3 GALAXY 281543964623104 1 0 0 268435456 281474976710656 22.1101 18.2751 17.998 18.9031 17.7235 7.90499 0.0901843 0.102999 0.369229 0.473264 7.90499 0.0901843 0.102999 0.369229 0.473264 0.268779 0.197765 0.143436 0.108763 0.0771144 21.8413 18.0774 17.8545 18.7943 17.6464 68.3085 68.3064 68.3096 2.96992 68.3133 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 0.463227 5.39807 29.6657 13.5095 29.6692 6.49416 9.27581 8.17894 29.6748 3.68339 0.11152 0.891638 0.396979 0.375163 0.775948 24.8217 1.0623 18.6927 0.0978314 18.5332 0.120832 20.3822 0.184582 18.4185 0.387561 24.3191 0.840614 23.5131 0.209655 22.8978 0.176464 22.8481 0.237401 22.6449 0.475214 25.0635 0.943435 23.2805 0.222519 22.6838 0.192913 22.3861 0.226053 22.4723 0.619582 0.983089 0.481738 0.553918 1.0 0.824531 1.86374 -0.0384043 -0.00975352 -0.00438696 -0.525557 0.0635576 -0.587386 -0.00204263 -15.5564 3.41581 0.106464 0.379627 138.005 0.282182 56.3059 124.162 0.594347 43.1012 129.14 0.270333 2.20363 100.602 0.349897 15.8831 123.339 23.3248 0.22302 17.998 0.102999 24.3924 37.7707 18.4547 28.165852369 27.3864612804 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.09755 -1.0 -1 0.185551 0.073029 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 24.4864852316 199.582853204 -1 -1 0.0888581654168 -1.0 -1 AAT /Spectra/Final/AAT/Gilgamesh2016_1_MG.mz -- 68.0 AAT
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1237657607497319524 123.266748996 36.2563919523 3 GALAXY 281543964754176 1 0 0 268435456 281474976710656 19.0522 19.2372 17.9144 17.2204 17.5169 0.411172 0.224786 0.10221 0.0724711 0.360557 0.411172 0.224786 0.10221 0.0724711 0.360557 0.353102 0.259809 0.188435 0.142885 0.101307 18.6991 18.9774 17.726 17.0775 17.4156 2.97049 1.08863 2.97014 2.97069 2.9702 -1000.0 1.04829 -1000.0 -1000.0 -1000.0 29.672 11.198 29.6811 2.73206 29.6674 15.1505 21.513 6.28274 29.6744 3.45764 0.0976059 0.402864 0.840093 0.999755 0.275351 18.6431 0.263517 19.276 0.203083 18.2309 0.109273 16.9518 0.0800317 18.6084 0.324273 24.5647 0.842444 24.1921 0.427796 22.5603 0.174921 22.0947 0.124769 21.9884 0.364067 24.3417 0.937564 24.6584 0.637932 22.7357 0.23258 22.1623 0.188107 22.1378 0.469056 0.0 0.0 0.501777 0.392969 0.465991 -0.491102 3.81454 -2.48842 10.8364 -0.228199 -0.279212 -0.131653 0.0493391 -0.276534 0.37841 0.220964 59.3438 -7.66168 0.188699 59.3474 123.801 0.459167 44.8197 112.898 0.731369 59.2537 82.3929 0.0814524 30.6991 65.0848 23.29 0.249701 17.9144 0.10221 3.88695 5.6439 20.9643 28.167178604 25.9077941158 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 -0.00116 -1.0 -1 0.311371 0.129749 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 1.25045157514 13.7268445302 -1 -1 0.117218903329 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0206_1.zlog -- 258.0 MMT
1237657607497319275 123.268135605 36.2440139751 3 GALAXY 68987912448 1 0 0 268435456 0 18.2168 18.2691 17.1063 16.4787 16.09 0.259743 0.127589 0.0671022 0.0507431 0.136208 0.259743 0.127589 0.0671022 0.0507431 0.136208 0.353994 0.260465 0.188911 0.143246 0.101563 17.8628 18.0086 16.9174 16.3355 15.9884 1.04971 2.97081 2.97014 2.22609 2.9702 0.132542 -1000.0 -1000.0 0.101043 -1000.0 0.794462 1.47012 29.6797 3.40946 29.668 9.28566 25.1167 5.23712 29.6737 3.43809 0.05 0.720005 0.897121 0.999664 0.838402 22.385 0.275027 19.9034 0.15927 17.4533 0.0747911 18.4146 0.0765363 17.5311 0.157976 22.502 0.244602 22.9981 0.169738 22.3214 0.143097 21.5908 0.0821038 21.37 0.248172 22.9068 0.389042 23.1127 0.217517 22.3712 0.16871 21.4085 0.0964894 20.9697 0.238479 0.523537 0.602172 0.408085 0.498072 0.641105 -0.0786209 -0.241685 -0.072131 0.0742269 0.0232091 -0.0397222 -0.0105172 0.123846 0.201042 -0.0990881 0.05 0.192508 -2.79607 0.78835 1.89472 20.5028 0.466748 59.3487 30.6689 0.76682 1.02198 0.922928 0.378496 4.17523 97.6086 22.9764 0.192895 17.1063 0.0671022 3.41266 5.47938 20.766 27.9687904535 25.4269557478 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.705065 0.000219445 4 0.134896 0.064958 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 1.45857268371 16.0114959301 -1 -1 0.0617401207529 -1.0 -1 SDSS SDSS -- SDSS
1237657594075873891 123.485301366 36.1920509675 3 GALAXY 281573022892360 0 0 0 268435456 281474976710656 20.646 18.0466 18.0624 17.2057 18.2345 1.62524 0.0693096 0.112594 0.0806454 0.759757 1.62524 0.0693096 0.112594 0.0806454 0.759757 0.349009 0.256797 0.186251 0.141228 0.100133 20.297 17.7898 17.8762 17.0644 18.1344 2.97001 2.97034 2.9702 106.735 2.9699 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.5063 67.3726 29.6697 9.43842 29.6679 16.7113 29.6728 2.86907 5.70006 16.009 0.05 0.945779 0.994325 0.895638 0.05 19.6517 0.632895 17.6949 0.0643936 17.8936 0.115951 17.3413 0.0842618 20.863 0.520587 24.8778 0.634079 23.2832 0.151601 23.4143 0.273336 22.8637 0.254549 22.3036 0.38162 24.3642 0.899972 23.0764 0.20065 22.9534 0.282362 22.4896 0.287537 22.0307 0.577743 0.0 0.159653 0.498361 0.216888 0.469988 83.763 -27.2728 5.3747 0.244216 0.0700574 -0.0374293 3.40751 0.465809 -36.7632 7.9453 0.19999 57.2475 -3.77538 0.343645 59.3515 77.5204 0.538358 54.1492 33.7728 0.197327 59.3413 52.662 0.05 2.73835 9.39628 23.5697 0.31158 17.453 0.102445 30.5953 43.2366 17.7478 28.1164123114 27.1715478383 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.971988 -1.0 -1 0.564412 0.075658 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 12.4062186273 136.189095041 -1 -1 0.184927684955 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0206_1.zlog -- 267.0 MMT
1237648704056918638 221.504039494 -0.240567589235 3 GALAXY 52845546177296 1 0 0 268435456 0 17.6229 17.9041 16.9649 16.7331 17.2325 0.163118 0.102859 0.0682047 0.0803632 0.519515 0.163118 0.102859 0.0682047 0.0803632 0.519515 0.21132 0.155487 0.112772 0.085512 0.060629 17.4116 17.7486 16.8522 16.6476 17.1718 258.367 2.96972 258.37 3.315 0.818134 -1000.0 -1000.0 -1000.0 0.136382 0.135854 29.6705 2.45135 29.6639 11.0734 29.6672 3.12762 0.253269 0.131049 0.000135556 0.138849 0.42502 0.538709 0.601598 0.210616 0.222345 18.3199 0.191815 18.3312 0.109262 17.5832 0.0840231 17.9403 0.133691 19.8555 1.03577 24.7223 0.678476 23.2743 0.182587 22.0581 0.0880563 21.2764 0.0639696 20.5631 0.132877 24.1202 0.748857 23.3323 0.249324 22.2868 0.148185 21.4401 0.0722155 20.9861 0.274114 0.0 0.335081 0.552047 0.676015 0.938015 -51.7121 2.83305 2.92532 0.00587911 2.5891 0.0107362 10.8195 -0.00207877 -13.9271 1.68444 0.291872 59.3439 161.148 0.518622 59.3342 155.247 0.79165 55.532 36.0415 0.643251 59.3263 179.371 0.359643 59.3151 146.242 22.7956 0.156746 16.9649 0.0682047 157.653 239.997 14.9245 27.6831136478 27.9084416751 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.07363 -1.0 -1 0.303188 0.0506 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 2.73070320809 20.1702445683 -1 -1 0.0629745892991 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 264.0 AAT
1237648704056919200 221.58942673 -0.248144544458 3 GALAXY 2451151389512 1 0 0 268435456 0 18.1802 18.3409 17.4503 17.3725 26.4675 0.211141 0.120868 0.0831738 0.114914 2.51247 0.211141 0.120868 0.0831738 0.114914 2.51247 0.216813 0.159529 0.115704 0.0877347 0.062205 17.9633 18.1814 17.3346 17.2848 26.4053 258.367 2.96972 258.37 1.65875 1.77913 -1000.0 -1000.0 -1000.0 1.541 0.644359 29.6652 8.75416 27.779 23.089 29.6677 3.19814 29.659 3.50363 0.33458 0.791724 0.40102 0.0782523 0.436517 0.951771 0.05 18.4847 0.23076 18.7257 0.129552 17.9284 0.0988028 17.828 0.126951 21.1413 0.262743 23.9699 0.406691 23.6382 0.229467 22.6815 0.147506 22.1428 0.12952 21.2585 0.971426 24.0689 0.743452 23.5039 0.278171 22.6435 0.202679 22.1412 0.191646 21.5349 0.901799 0.368288 0.259544 0.453644 0.580521 1.0 1243.81 -136.852 2.33251 0.0116446 -0.56242 -1.12394e-05 0.453082 0.00276377 0.681072 0.807673 0.429053 59.3362 14.2161 0.331425 59.3337 0.0250608 0.436563 59.3333 154.481 0.451862 59.3157 70.83 0.988542 46.8226 40.2159 23.232 0.225121 17.4503 0.0831738 150.19 246.896 15.2301 28.3122558135 28.1087268784 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.32443 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 3.01258395388 22.2523464157 -1 -1 0.0407829371293 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 77.0 AAT
1237648704056918832 221.581274221 -0.224492464984 3 GALAXY 387099228504848 0 0 0 268435456 281474976710656 18.4297 18.206 17.1074 16.6178 16.0783 0.278102 0.113389 0.0647157 0.0609433 0.153021 0.278102 0.113389 0.0647157 0.0609433 0.153021 0.222998 0.16408 0.119004 0.0902373 0.0639794 18.2067 18.0419 16.9884 16.5276 16.0144 2.18936 2.96972 2.96977 258.294 3.25438 2.06922 -1000.0 -1000.0 -1000.0 1.98869 29.6648 10.6121 20.966 12.1504 29.6695 1.76307 29.6574 3.87525 29.6693 3.4106 0.0809721 0.999728 0.551552 0.456388 0.728767 19.7148 0.232711 17.7264 0.10602 16.888 0.0616732 17.0139 0.0708338 16.2571 0.182269 23.1376 0.339764 25.0265 0.404619 24.701 0.706096 22.3551 0.184042 21.2064 0.217905 23.16 0.412906 23.9214 0.425384 22.8081 0.322507 21.7385 0.144564 21.0519 0.28513 0.455401 0.0 0.0 0.379104 0.483046 -50.4748 -5.84197 -0.201059 -0.0378848 7.02387 0.00520245 -1.29418 0.00387309 2.54708 0.0410603 0.05 47.6297 37.4765 0.914249 59.3393 84.2889 0.634261 59.3349 26.0442 0.480676 59.3197 57.7643 0.778768 59.3284 134.655 23.4381 0.364775 16.888 0.0616732 172.604 243.56 14.905 27.7499738756 28.0857491071 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.807516 -1.0 -1 0.208863 0.098833 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 2.11848063446 15.6480844102 -1 -1 0.0719680357765 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0418_4.zlog -- 46.0 MMT
1237648704056919077 221.491946199 -0.246978545646 3 GALAXY 281543964623616 1 0 0 268435456 281474976710656 18.0713 19.0798 18.0044 18.0808 18.108 0.175837 0.216441 0.12516 0.200094 0.853003 0.175837 0.216441 0.12516 0.200094 0.853003 0.205849 0.151462 0.109853 0.0832978 0.0590592 17.8654 18.9284 17.8945 17.9975 18.0489 2.96973 258.366 258.37 1.87237 3.01659 -1000.0 -1000.0 -1000.0 0.694763 2.87304 29.6659 6.23406 29.6665 6.80338 29.6673 41.958 6.62436 4.32084 16.2828 17.9476 0.387208 0.585058 0.05 0.152501 0.199993 19.4388 0.2649 19.9492 0.214401 19.541 0.190804 20.3204 0.28509 18.8983 0.265153 23.8312 0.53877 23.9275 0.296421 22.8458 0.172082 22.4827 0.174125 21.6393 0.3101 24.6218 0.828583 23.8286 0.359645 22.8032 0.232691 22.4056 0.241366 21.4107 0.379432 0.0 0.917707 0.886661 0.941867 1.0 128.762 43.7553 12.8221 -0.304422 -13.3646 -0.0654855 25.3719 1.77441 -34.1503 62.4247 0.05 59.3299 61.0809 0.550986 46.4905 138.051 0.352816 59.3293 39.4242 0.219714 52.6829 48.1912 0.249951 8.98258 34.9879 23.3717 0.251356 18.0044 0.12516 200.822 251.364 14.9041 28.8661916699 28.4135712375 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.16977 -1.0 -1 0.234543 0.103909 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 3.54940435518 26.2175503044 -1 -1 0.0581705793379 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 165.0 AAT
1237648704057050440 221.89003593 -0.250720211145 3 GALAXY 281543964754176 1 0 0 268435456 281474976710656 17.4201 18.082 17.4835 28.9864 28.1395 0.122263 0.110969 0.098641 1.19192 0.636406 0.122263 0.110969 0.098641 1.19192 0.636406 0.231993 0.170699 0.123805 0.0938774 0.0665603 17.1881 17.9113 17.3597 28.8925 28.073 2.9696 2.96936 68.2773 1.07304 0.929243 -1000.0 -1000.0 -1000.0 0.227757 0.147784 29.6686 2.47339 27.5249 16.8701 29.6596 2.31845 0.00125587 1.47615 0.225599 2.19508 0.559254 0.999723 0.887207 0.0552194 0.0990718 17.851 0.134328 17.8414 0.109251 18.0062 0.114047 22.0233 0.130206 21.2867 0.265465 23.7277 0.411285 23.5328 0.205488 22.5042 0.131058 21.9975 0.121189 21.4401 0.25009 24.0605 0.392863 23.7383 0.337665 22.5447 0.186456 22.4629 0.253884 21.8154 0.511801 0.0 0.0 0.557617 1.0 1.0 -3.46507 0.0418849 -0.0928087 0.00453229 -0.0576587 0.0107331 0.279076 -0.00296923 0.287712 0.0476231 0.324976 59.3378 124.533 0.843122 59.3239 163.471 0.653365 55.7332 3.03069 0.0760545 0.000546484 0.025026 0.097268 0.378867 146.784 23.1019 0.203107 17.4835 0.098641 29.23 41.6002 18.204 28.2094778544 27.5285801268 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 -0.00052 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 20.7091567454 152.966559188 -1 -1 0.0598754690909 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 4.0 AAT
1237678881574814449 39.5740150838 -1.3493833882 3 GALAXY 68988044032 1 0 0 268435456 0 20.8693 17.353 17.1039 19.5849 19.4264 3.24967 0.0531143 0.0768591 1.20827 3.7658 3.24967 0.0531143 0.0768591 1.20827 3.7658 0.159765 0.117554 0.0852598 0.0646499 0.0458376 20.7095 17.2354 17.0186 19.5202 19.3806 106.765 2.97021 106.748 1.89058 2.94955 -1000.0 -1000.0 -1000.0 0.248242 0.980372 10.0558 64.2043 19.0334 5.73575 29.6803 1.54114 1.28254 0.803606 1.38133 1.27156 0.997767 0.999732 0.980931 0.173019 0.05 20.696 2.08386 17.1865 0.0528542 17.4638 0.0852813 20.511 0.0922846 20.0304 0.201246 24.5074 1.06983 23.1409 0.192693 21.8712 0.109353 21.2044 0.0916645 20.6353 0.191687 24.8251 1.06136 23.3281 0.255438 21.9467 0.13743 21.255 0.119478 20.8742 0.289246 0.0 0.0223779 0.445076 1.0 1.0 -0.619692 0.00169951 -0.19956 0.00107708 -0.148949 -0.00661269 -0.0258697 -0.033625 0.0304071 -0.0240727 0.231359 59.3686 -1.39267 0.610742 59.3511 73.4515 0.549983 53.7174 53.6023 0.300266 0.986955 33.7534 0.05 50.7165 86.1502 22.5322 0.156461 17.1039 0.0768591 34.3275 56.9651 17.3086 27.7499539971 26.9822771496 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.59201 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 2.40288517604 25.9702640708 -1 -1 0.0140907956488 -1.0 -1 AAT /Spectra/Final/AAT/Narnia2016_1_MG.mz 2 148.0 AAT
1237678890137617086 39.777894837 -1.55434837171 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 19.8586 18.4253 17.9279 17.7033 16.084 1.43942 0.158591 0.193611 0.260706 0.204893 1.43942 0.158591 0.193611 0.260706 0.204893 0.165154 0.121519 0.0881357 0.0668306 0.0473837 19.6935 18.3038 17.8398 17.6364 16.0367 1.71794 258.44 258.431 0.851923 2.9705 1.58874 -1000.0 -1000.0 0.43973 -1000.0 2.63225 5.47351 27.8571 19.6265 29.6728 8.74795 7.86942e-05 0.298385 29.6714 20.2509 0.05 0.433778 0.694256 0.363236 0.437898 21.1662 0.869338 19.3242 0.202851 19.6229 0.230792 22.643 0.299502 16.1246 0.25753 22.949 0.364106 22.9782 0.15531 23.1169 0.274358 22.6051 0.276784 22.7807 0.651364 23.0352 0.481413 23.2887 0.247216 22.9869 0.349727 23.0592 0.583592 22.4277 0.850042 0.813747 0.731584 0.645975 0.771205 0.0 -40.6828 -5.89377 6.95072 0.00938994 7.50323 0.0448874 20.9478 0.230167 57.1811 12.8619 0.0999834 56.6866 61.1518 0.65217 56.3096 150.696 0.152866 5.2939 30.4041 0.0512159 0.00984645 80.7317 0.719869 51.7383 161.699 23.5204 0.36134 21.3014 0.227716 -9999.0 -9999.0 33.8672 26.9157771651 55.8624276422 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.02839 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 19.7388478272 213.33533565 -1 -1 0.298876430749 -1.0 -1 AAT /Spectra/Final/AAT/Narnia2016_1_MG.mz -- 48.0 AAT

Look at various mags to see if there are any that are v different



In [98]:

    
magcols = ('OBJID', 'RA', 'DEC', 'r', 'CMODELMAG_R', 'PETROMAG_R', 'FIBERMAG_R', 'PSFMAG_R')

Look at the bright things that are good in SAGA - are any of them discrepent in various mags?



In [144]:

    
bright_good = saga_spectra[(saga_spectra['r']<18)&(saga_spectra['ZQUALITY']>=3)&(saga_spectra['REMOVE']==-1)]



In [145]:

    
for col in magcols[3:]:
     plt.hist(bright_good[col],histtype='stepfilled', bins=50, range=(10, 25), label=col, alpha=.5)
plt.legend()
plt.tight_layout()

Now what about the bright things that got no spectra?



In [123]:

    
for col in magcols[3:]:
     plt.hist(saga_spectra_matches[col], 
              histtype='stepfilled', bins=50, range=(10, 25), label=col, alpha=.5)
plt.legend()
plt.tight_layout()

So maybe either the fibermag or psfmag difference from regular mag is what we want?



In [146]:

    
fibdiff_bright_good = bright_good['FIBERMAG_R'] - bright_good['r']
psfdiff_bright_good = bright_good['PSFMAG_R'] - bright_good['r']

fibdiff_saga_spectra_matches = saga_spectra_matches['FIBERMAG_R'] - saga_spectra_matches['r']
psfdiff_saga_spectra_matches = saga_spectra_matches['PSFMAG_R'] - saga_spectra_matches['r']



In [148]:

    
histkwargs = dict(histtype='stepfilled', bins=50, range=(-5, 10), normed=True, alpha=.5)

plt.hist(fibdiff_bright_good, label='fibmag bright_good_spectrum', **histkwargs)
plt.hist(psfdiff_bright_good, label='psfmag bright_good_spectrum', **histkwargs)

plt.hist(fibdiff_saga_spectra_matches, label='fibmag bright_badspec', **histkwargs)
plt.hist(psfdiff_saga_spectra_matches, label='psfmag bright_badspec', **histkwargs)

plt.xlabel('(X)mag - r')

plt.legend(loc=0)
plt.tight_layout()

Check the things that are bright_good_spectrum and have a strong offset in the above plot



In [152]:

    
targeting.sampled_imagelist(bright_good[fibdiff_bright_good>4], None, n=200)









    Out[152]:





'name ra dec\n0 144.738000449 0.692730437834\n1 180.676016887 1.97680307584\n2 180.720075372 1.97341672816\n3 180.650410075 2.01463800046\n4 180.700014612 2.01490982113\n5 181.120699376 1.89409150163\n6 181.160379565 1.82033909715\n7 180.609402045 1.35335292205\n8 139.49713703 52.7427116605\n9 139.007226013 52.8406351395\n10 154.231241268 58.3949131454\n11 156.291099368 58.1500435129\n12 123.241350605 36.2546358801\n13 123.272247904 36.2473829807\n14 123.260511963 36.2342399437\n15 122.502655517 36.7907934208\n16 193.84130214 58.3441767226\n17 193.766660952 58.7906790437\n18 195.531005137 58.6982005772\n19 354.350599991 0.390802769345\n20 354.195229736 0.62342377148\n21 353.502228839 0.214990397491\n22 353.235047336 0.21457743747\n23 353.914959168 1.19838788255\n24 353.722358394 1.20743944443\n25 210.708471008 49.1726221013\n26 210.220300497 49.3754537481\n27 210.207365611 49.5161574869\n28 210.198604018 48.4438973483\n29 210.664533166 50.0315031866\n30 149.587831028 32.3699118019\n31 149.697698014 32.0860628952\n32 149.050604971 32.2308450967\n33 209.23332661 29.1643608214\n34 209.710537142 28.926337182\n35 208.436541314 28.6070682794\n36 207.304409485 33.3168537413\n37 0.995575122267 20.7524099889\n38 8.26672559122 -8.11407639836\n39 9.03686385221 -7.53733382641\n40 20.4490124086 17.5921777276\n41 20.661342768 17.418544698\n42 20.0710551791 17.7406401525\n43 20.151127333 17.8444843063\n44 20.2533019933 17.0739484929\n45 21.0162754036 12.9174623621\n46 20.3269430927 12.4108222961\n47 24.5004818322 -7.5654384584\n48 29.070580025 4.64673794928\n49 34.4564849708 6.29468048722\n50 39.590752179 -1.34547481379\n51 39.5794528322 -1.34164316333\n52 38.7497919136 -1.22681864215\n53 126.865163194 25.7243689745\n54 136.140613263 45.2919665856\n55 137.962155506 34.9637406847\n56 138.184974166 34.9255496114\n57 138.039733341 35.5315898799\n58 138.614749628 35.8056167882\n59 141.141087343 34.6588051715\n60 140.813271688 34.7343539788\n61 141.450424263 34.2768708872\n62 141.506228227 34.6534021854\n63 140.089099865 34.2384595037\n64 140.135362115 34.2720941265\n65 141.54318179 33.7211060635\n66 157.723737809 28.610560817\n67 162.804228149 28.0062048696\n68 162.845977488 28.0241634592\n69 162.816110258 27.8489705993\n70 162.904734277 27.822117387\n71 162.303384997 27.922597647\n72 163.076959821 27.3868174776\n73 163.648003232 56.9908480418\n74 164.087037522 56.7597565956\n75 163.343679288 57.6266939742\n76 162.354133872 57.3355347392\n77 166.166476593 27.7236126599\n78 165.450695089 28.6903520809\n79 171.092168079 39.2457388507\n80 171.841391155 40.0130276988\n81 169.507540806 40.3687543784\n82 171.784892487 25.0654130784\n83 171.660015298 26.360766183\n84 175.32773435 36.546807604\n85 175.563531091 36.2980602831\n86 175.32552486 35.730848103\n87 174.139030128 36.4102743292\n88 177.285742962 27.0850925483\n89 177.348303087 26.7416474578\n90 176.70799676 27.1605063161\n91 177.518568227 26.4792599987\n92 176.777534075 27.418684858\n93 179.443282304 6.26675022836\n94 180.09842901 -1.10007802185\n95 180.023180449 -1.30894238248\n96 180.29544216 -1.2976838319\n97 180.366362438 -0.718388624729\n98 179.69172842 -1.46194133403\n99 179.803471021 -0.524878147102\n100 180.693874929 -1.59366277765\n101 179.950501076 -1.94281295176\n102 179.819352902 -1.91537912137\n103 187.211462246 -1.93918482095\n104 187.442561485 -1.29504567431\n105 186.549581248 -1.30491987911\n106 194.667484681 14.2169187447\n107 195.105563951 13.6705858419\n108 194.572104136 14.5571518823\n109 194.537592798 14.8589422167\n110 207.161709725 43.4133397464\n111 209.069456113 47.2357010163\n112 209.270743639 41.846269946\n113 209.279024597 41.7931182683\n114 208.722173378 41.3134949091\n115 215.996558889 49.8364415016\n116 215.186545934 51.1382181749\n117 219.82947956 53.8754694368\n118 218.844748187 5.27638835668\n119 224.007002415 -1.3882658841\n120 223.929455865 -1.0081740936\n121 228.132390663 0.812559956425\n122 226.564113606 0.218922218177\n123 248.107225465 19.7944042767\n124 248.077615933 19.7786388645\n125 247.84002995 20.1840758135\n126 248.188391892 19.4285832369\n127 248.427180811 19.578559917\n128 247.96044807 19.296670725\n129 247.586344578 20.5748995768\n130 254.536088857 22.9851005802\n131 336.048161241 -3.48293869003\n132 339.371985666 10.531525229\n133 339.984242949 11.0275614184\n134 343.923576279 -5.49534576909\n135 344.643032572 -4.9383423548\n136 345.869006754 12.9756498675\n137 345.299217352 12.7238894309\n138 348.682907878 4.53406240861\n139 348.688707101 5.41610694094\n140 359.91811187 20.1010169363\n141 145.759229254 5.02838334971\n142 145.711855575 4.88928917374\n143 159.067726542 37.3246831431\n144 159.501144764 36.6965255117\n145 160.160824414 37.3331780403\n146 169.588863841 45.7481921726\n147 169.549435328 45.7170252683\n148 170.070870294 45.3896500134\n149 174.843068177 56.2707271839\n150 174.462550762 56.1419973787\n151 173.821660966 56.7945806734\n152 176.398645933 55.8869907737\n153 182.813356421 20.1720417426\n154 182.787329955 20.1590590102\n155 182.827067775 20.1834424077\n156 182.528619474 20.2239552236\n157 193.461822584 9.71003051934\n158 194.083349645 10.188749177\n159 192.748609382 9.07787538369\n160 193.76686454 7.72142546481\n161 193.265498796 7.68321144157\n162 193.847646665 7.91004544913\n163 198.174169838 22.8298213652\n164 206.329877581 41.7125475739\n165 206.719277822 41.3037537566\n166 206.603133879 46.1070049769\n167 206.144498165 46.4098073164\n168 216.362007305 56.3202828666\n169 217.412582018 3.26627642199\n170 217.266218915 3.14899055549\n171 218.850481331 57.2560014619\n172 221.546363418 -0.222941918742\n173 221.554313308 -0.257058674766\n174 221.557372584 -0.253814115047\n175 221.580908703 -0.225620095335\n176 221.58534909 -0.2292639435\n177 221.529055044 -0.268906191902\n178 221.859117992 -0.281411495132\n179 221.520745215 -0.799735916133\n180 220.751892724 -0.382674524979\n181 222.324432845 0.389442797935\n182 222.900268358 58.9548243013\n183 224.540646344 58.8717820704\n184 227.920600638 59.8089907583\n185 229.699903853 59.4625017503\n186 230.337609035 5.04489799251\n187 230.316833152 4.45071244053\n188 234.132011282 16.6077737961\n189 234.10481828 16.5752509005\n190 234.141758655 16.5679114609\n191 234.123567095 16.643347491\n192 234.132926177 16.4404552908\n193 233.793232948 16.549942888\n194 234.343712643 16.2500311847\n195 233.787037531 16.8704375988\n196 234.003146313 16.1309111097\n197 234.293337683 17.3077372848'



In [165]:

    
np.sum(bright_good['PETRORADERR_R']<0)/len(bright_good)









    Out[165]:





0.0054843890782308924



In [168]:

    
t = bright_good[fibdiff_bright_good>4]
np.sum(t['PETRORADERR_R']<0)/len(t)









    Out[168]:





0.25252525252525254



In [169]:

    
np.sum(saga_spectra_matches['PETRORADERR_R']<0)/len(saga_spectra_matches)









    Out[169]:





0.875

Working theory: PETRORADERR_R< 0 + fibmag offset>4 is a good selection?



In [170]:

    
# the things we want to *remove*, except maybe the one that looks like a gal
targeting.sampled_imagelist(saga_spectra_matches, None, 
                            names=['petrerr_r={}'.format(row['PETRORADERR_R']) for row in saga_spectra_matches])









    Out[170]:





'name ra dec\nprerr_r=-1000.0 354.149256048 0.327135654889\nprerr_r=1.98957622051 354.082573493 0.0606011959357\nprerr_r=-1000.0 247.644214855 19.9588877603\nprerr_r=-1000.0 335.944149612 -3.42971396292\nprerr_r=0.418006330729 335.972808358 -3.42956615144\nprerr_r=-1000.0 335.826943253 -3.64921666464\nprerr_r=-1000.0 335.809245892 -3.0283746526\nprerr_r=-1000.0 354.149256048 0.327135654889\nprerr_r=1.98957622051 354.082573493 0.0606011959357\nprerr_r=-1000.0 234.33322017 16.248215191\nprerr_r=-1000.0 233.633939264 16.5596769815\nprerr_r=-1000.0 233.633959197 16.5561911883\nprerr_r=-1000.0 233.609145097 16.5288963457\nprerr_r=-1000.0 233.974461564 16.0388317753\nprerr_r=-1000.0 123.266748996 36.2563919523\nprerr_r=-1000.0 123.268135605 36.2440139751\nprerr_r=-1000.0 123.485301366 36.1920509675\nprerr_r=-1000.0 221.504039494 -0.240567589235\nprerr_r=-1000.0 221.58942673 -0.248144544458\nprerr_r=-1000.0 221.581274221 -0.224492464984\nprerr_r=-1000.0 221.491946199 -0.246978545646\nprerr_r=-1000.0 221.89003593 -0.250720211145\nprerr_r=-1000.0 39.5740150838 -1.3493833882\nprerr_r=-1000.0 39.777894837 -1.55434837171'



In [183]:

    
# these are bright_good things we'd be *removing*
msk = (fibdiff_bright_good>4)&(bright_good['PETRORADERR_R']<0)
t = bright_good[msk]
s = targeting.sampled_imagelist(t, None, n=len(t), 
                            names=['fibmag-r={}'.format(fd, prer) for fd, prer in 
                                   zip(fibdiff_bright_good[msk], bright_good[msk]['PETRORADERR_R'])])
len(t)/len(bright_good)









    Out[183]:





0.001958710385082462



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]:



In [ ]:

Extra stuff not in order with the above

What about the real sats that have fiber mag that's very small?



In [111]:

    
bright_smallfib = bright_good[bright_good['FIBERMAG_R']>21]

bright_smallfib_sats = bright_smallfib[bright_smallfib['SATS']==1]
targeting.sampled_imagelist(bright_smallfib_sats,None)
bright_smallfib_sats









    Out[111]:




<Table masked=True length=2>

OBJID RA DEC PHOTPTYPE PHOT_SG FLAGS clean SATURATED BAD_COUNTS_ERROR BINNED1 TOO_FEW_GOOD_DETECTIONS u g r i z u_err g_err r_err i_err z_err MODELMAGERR_U MODELMAGERR_G MODELMAGERR_R MODELMAGERR_I MODELMAGERR_Z EXTINCTION_U EXTINCTION_G EXTINCTION_R EXTINCTION_I EXTINCTION_Z DERED_U DERED_G DERED_R DERED_I DERED_Z PETRORAD_U PETRORAD_G PETRORAD_R PETRORAD_I PETRORAD_Z PETRORADERR_U PETRORADERR_G PETRORADERR_R PETRORADERR_I PETRORADERR_Z DEVRAD_U DEVRADERR_U DEVRAD_G DEVRADERR_G DEVRAD_R DEVRADERR_R DEVRAD_I DEVRADERR_I DEVRAD_Z DEVRADERR_Z DEVAB_U DEVAB_G DEVAB_R DEVAB_I DEVAB_Z CMODELMAG_U CMODELMAGERR_U CMODELMAG_G CMODELMAGERR_G CMODELMAG_R CMODELMAGERR_R CMODELMAG_I CMODELMAGERR_I CMODELMAG_Z CMODELMAGERR_Z PSFMAG_U PSFMAGERR_U PSFMAG_G PSFMAGERR_G PSFMAG_R PSFMAGERR_R PSFMAG_I PSFMAGERR_I PSFMAG_Z PSFMAGERR_Z FIBERMAG_U FIBERMAGERR_U FIBERMAG_G FIBERMAGERR_G FIBERMAG_R FIBERMAGERR_R FIBERMAG_I FIBERMAGERR_I FIBERMAG_Z FIBERMAGERR_Z FRACDEV_U FRACDEV_G FRACDEV_R FRACDEV_I FRACDEV_Z Q_U U_U Q_G U_G Q_R U_R Q_I U_I Q_Z U_Z EXPAB_U EXPRAD_U EXPPHI_U EXPAB_G EXPRAD_G EXPPHI_G EXPAB_R EXPRAD_R EXPPHI_R EXPAB_I EXPRAD_I EXPPHI_I EXPAB_Z EXPRAD_Z EXPPHI_Z FIBER2MAG_R FIBER2MAGERR_R EXPMAG_R EXPMAGERR_R PETROR50_R PETROR90_R PETROMAG_R SB_EXP_R SB_PETRO_R J JERR H HERR K KERR SPEC_Z SPEC_Z_ERR SPEC_Z_WARN PHOTOZ PHOTOZ_ERR W1 W1ERR W2 W2ERR HOST_RA HOST_DEC HOST_DIST HOST_VHOST HOST_MK HOST_NSAID HOST_FLAG HOST_SAGA_NAME RHOST_ARCM RHOST_KPC OBJ_NSAID SATS PROBABILITY_CLASS1 RESCALED_PROBABILITY_CLASS1 REMOVE TELNAME MASKNAME ZQUALITY SPEC_CLASS SPECOBJID SPEC_REPEAT
int64 float64 float64 int16 str40 int64 int32 int64 int64 int64 int64 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float64 float64 float32 float32 float32 float32 float32 float32 float32 float32 int32 float32 float32 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64 str48 float64 float64 int64 int64 float64 float64 int64 str6 str48 int64 str2 str48 str48
1237667228223471668 34.4564849708 6.29468048722 3 GALAXY 35255541174616 0 0 0 268435456 0 15.9043 15.4342 15.3632 15.0431 -99.0 0.0503136 0.0143256 0.0343602 0.139791 0.0875026 0.154576 0.0338745 0.0601029 0.215043 1.10988 0.333093 0.245087 0.177757 0.134788 0.0955664 21.2894 20.5442 20.7151 21.7277 22.8531 1.47284 3.07161 1.65845 1.59846 2.97041 1.3414 0.160255 0.108122 0.382837 -1000.0 0.380657 0.929018 2.27832 0.385527 0.738574 0.333412 0.655921 2.092 0.283904 70.0553 0.0999995 0.699636 0.713542 0.05 0.229759 21.7672 0.392808 20.2781 0.0388224 20.8928 0.0920885 21.983 0.450744 22.99 4.15853 21.9654 0.170399 21.4341 0.0466062 21.4402 0.0791677 22.4143 0.223826 23.1191 0.683259 21.6331 0.141289 21.1902 0.0424327 21.1542 0.0693863 21.7453 0.201541 22.0091 4.68785 0.0 0.22388 0.0 0.876136 0.0 0.0625673 -0.065178 -0.0211262 0.0176206 0.0142408 -0.00128577 0.139752 0.0723178 0.690597 3.04668 0.296689 0.523009 145.3 0.746344 1.41153 96.5558 0.779925 0.69977 142.691 0.05 0.591346 19.6805 0.673114 0.31652 44.3738 21.8465 0.0878419 20.8928 0.0920885 0.934878 1.49912 21.0499 22.1130530087 22.8991184069 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00519694 -1.0 0 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 33.8651 6.00248 20.6466 1562.0 -23.06324272 131531 0 39.3874952535 236.550310958 131609 1 0.435620214674 -1.0 -1 NSA ned 4 1.23766722822e+18 NSA
1237664337178788133 175.563531091 36.2980602831 3 GALAXY 105622137733208 0 0 0 268435456 0 18.3103 17.3519 17.0066 16.6657 16.6971 0.076692 0.0106417 0.0178551 0.0199619 0.0548733 0.216618 0.118535 0.180281 0.197141 0.723844 0.0943027 0.069387 0.0503252 0.0381601 0.027056 22.1403 22.3718 22.2103 21.9348 22.7755 1.55861 1.52655 1.55302 1.5262 0.674857 0.304761 0.217325 0.295551 0.327641 0.238354 0.287834 1.61724 0.294085 0.519152 0.236273 1.45102 0.31401 1.79268 0.0427931 220.845 0.05 0.206997 0.681292 0.288203 0.578539 22.2458 0.4058 22.4468 0.257024 22.2606 0.722022 21.9787 0.718815 22.8177 5.183 22.2886 0.22739 22.5932 0.164694 22.3974 0.232496 22.152 0.23899 22.8304 0.836933 21.9774 0.188703 21.5898 0.0747299 21.2777 0.0860818 21.2412 0.122903 20.9491 0.39159 1.0 0.0 0.0 0.0 0.0 0.0407523 0.111773 -0.0681097 -0.00436986 0.0243384 -0.0217834 0.0793985 -0.106561 -0.145641 0.119391 0.0608827 0.413605 129.204 0.270238 0.453254 96.0956 0.749857 0.379026 159.104 0.323366 0.458423 149.353 0.746803 0.0436463 6.83858 22.1127 0.123281 22.2606 0.722022 0.811281 1.31041 22.47 22.1494026185 24.011259801 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00470981 -1.0 0 -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 175.328 36.5468 24.6947 1465.0 -23.1060187728 140065 0 18.746034364 134.659540527 89238 1 -1.0 -1.0 -1 NSA sdss 4 1.23766433718e+18 NSA



In [112]:

    
bright_smallfib_sats[magcols]









    Out[112]:




<Table masked=True length=2>

OBJID RA DEC r CMODELMAG_R PETROMAG_R FIBERMAG_R PSFMAG_R
int64 float64 float64 float32 float32 float32 float32 float32
1237667228223471668 34.4564849708 6.29468048722 15.3632 20.8928 21.0499 21.1542 21.4402
1237664337178788133 175.563531091 36.2980602831 17.0066 22.2606 22.47 21.2777 22.3974



In [82]:

    
scbright = SkyCoord(bright_tab['RA'], bright_tab['DEC'], unit=u.deg)
scdirty = SkyCoord(spectra['RA'], spectra['DEC'], unit=u.deg)

idx, d2d, _ = scbright.match_to_catalog_sky(scdirty)
t = spectra[idx[d2d<1*u.arcsec]]
t.sort('FIBERMAG_R')
targeting.sampled_imagelist(t, None, n=len(t), 
                            names=['fm_r={:.1f}_r={:.1f}'.format(ti['FIBERMAG_R'], ti['r']) for ti in t])
t









    Out[82]:




<Table masked=True length=24>

OBJID RA DEC PHOTPTYPE PHOT_SG FLAGS clean SATURATED BAD_COUNTS_ERROR BINNED1 TOO_FEW_GOOD_DETECTIONS u g r i z u_err g_err r_err i_err z_err MODELMAGERR_U MODELMAGERR_G MODELMAGERR_R MODELMAGERR_I MODELMAGERR_Z EXTINCTION_U EXTINCTION_G EXTINCTION_R EXTINCTION_I EXTINCTION_Z DERED_U DERED_G DERED_R DERED_I DERED_Z PETRORAD_U PETRORAD_G PETRORAD_R PETRORAD_I PETRORAD_Z PETRORADERR_U PETRORADERR_G PETRORADERR_R PETRORADERR_I PETRORADERR_Z DEVRAD_U DEVRADERR_U DEVRAD_G DEVRADERR_G DEVRAD_R DEVRADERR_R DEVRAD_I DEVRADERR_I DEVRAD_Z DEVRADERR_Z DEVAB_U DEVAB_G DEVAB_R DEVAB_I DEVAB_Z CMODELMAG_U CMODELMAGERR_U CMODELMAG_G CMODELMAGERR_G CMODELMAG_R CMODELMAGERR_R CMODELMAG_I CMODELMAGERR_I CMODELMAG_Z CMODELMAGERR_Z PSFMAG_U PSFMAGERR_U PSFMAG_G PSFMAGERR_G PSFMAG_R PSFMAGERR_R PSFMAG_I PSFMAGERR_I PSFMAG_Z PSFMAGERR_Z FIBERMAG_U FIBERMAGERR_U FIBERMAG_G FIBERMAGERR_G FIBERMAG_R FIBERMAGERR_R FIBERMAG_I FIBERMAGERR_I FIBERMAG_Z FIBERMAGERR_Z FRACDEV_U FRACDEV_G FRACDEV_R FRACDEV_I FRACDEV_Z Q_U U_U Q_G U_G Q_R U_R Q_I U_I Q_Z U_Z EXPAB_U EXPRAD_U EXPPHI_U EXPAB_G EXPRAD_G EXPPHI_G EXPAB_R EXPRAD_R EXPPHI_R EXPAB_I EXPRAD_I EXPPHI_I EXPAB_Z EXPRAD_Z EXPPHI_Z FIBER2MAG_R FIBER2MAGERR_R EXPMAG_R EXPMAGERR_R PETROR50_R PETROR90_R PETROMAG_R SB_EXP_R SB_PETRO_R J JERR H HERR K KERR SPEC_Z SPEC_Z_ERR SPEC_Z_WARN PHOTOZ PHOTOZ_ERR W1 W1ERR W2 W2ERR HOST_RA HOST_DEC HOST_DIST HOST_VHOST HOST_MK HOST_NSAID HOST_FLAG HOST_SAGA_NAME RHOST_ARCM RHOST_KPC OBJ_NSAID SATS PROBABILITY_CLASS1 RESCALED_PROBABILITY_CLASS1 REMOVE TELNAME MASKNAME ZQUALITY SPEC_CLASS SPECOBJID SPEC_REPEAT
int64 float64 float64 int16 str40 int64 int32 int64 int64 int64 int64 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float32 float64 float64 float32 float32 float32 float32 float32 float32 float32 float32 int32 float32 float32 float64 float64 float64 float64 float64 float64 float64 float64 float64 int64 int64 str48 float64 float64 int64 int64 float64 float64 int64 str6 str48 int64 str2 str48 str48
1237679996084618009 335.972808358 -3.42956615144 3 GALAXY 193585182019856 1 0 0 268435456 0 20.1496 18.5759 17.9106 17.654 17.4315 0.212052 0.0265917 0.0299772 0.0605004 0.074865 0.212052 0.0265917 0.0299772 0.0605004 0.074865 0.332555 0.244691 0.17747 0.13457 0.0954121 19.8171 18.3312 17.7332 17.5194 17.3361 2.96973 9.01185 10.2006 10.1937 8.38178 -1000.0 0.521633 0.418006 0.780476 1.20792 29.67 4.4335 14.8379 1.88275 14.3611 1.75306 15.6604 2.76502 15.3494 4.9481 0.909169 0.874766 0.936407 0.699987 0.846943 19.8191 0.211485 18.6436 0.0264928 17.9106 0.0351466 17.6327 0.0887886 17.5974 0.0898144 24.3825 0.96654 21.5681 0.0551883 21.3764 0.0576317 21.1532 0.0734761 20.4846 0.195213 23.324 3.87519 21.2772 0.0474032 20.6442 0.0408292 20.3021 0.0473202 20.0416 0.12304 0.0 0.0 0.0 0.0 0.0168801 -0.384395 -0.0329883 -0.0440571 -0.00066821 -0.0164063 0.00555766 -0.00919171 0.0140592 -0.0977588 0.0366081 0.640487 8.06442 125.031 0.92585 4.64061 123.121 0.91529 5.10972 73.306 0.750006 5.61678 57.984 0.911775 4.24964 77.2666 21.4674 0.0582251 17.9106 0.0351466 4.9025 10.142 17.9394 23.4480533959 23.3868944452 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.06411 -1.0 -1 0.095793 0.039418 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 3.58429435539 40.8459206448 -1 -1 0.0301093951356 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz -- 16.0 AAT
1237678879399411942 335.809245892 -3.0283746526 3 GALAXY 35253360132368 1 0 0 268435456 0 20.46 18.2557 17.5865 17.4144 20.308 0.872457 0.0526832 0.0466527 0.0591699 3.06308 0.872457 0.0526832 0.0466527 0.0591699 3.06308 0.335682 0.246991 0.179139 0.135836 0.0963091 20.1244 18.0087 17.4074 17.2786 20.2117 2.97065 2.96967 106.728 2.97036 0.562804 -1000.0 -1000.0 -1000.0 -1000.0 0.379493 29.6746 8.36016 16.5973 3.57407 29.67 2.81467 0.100151 0.098134 0.000221021 1.62263 0.387344 0.79445 0.795263 0.986523 0.171256 20.8185 0.886197 18.9018 0.0537474 17.6743 0.0475329 21.0265 0.0702893 21.91 1.05938 23.8669 1.08505 21.5643 0.252845 21.2966 0.449579 21.1434 0.581672 21.8594 0.5107 22.6916 0.319221 21.5964 0.245781 21.0996 0.55142 20.7665 0.642724 20.5281 0.142662 1.0 0.874706 0.652507 0.680091 1.0 90.7772 -1.74338 0.898356 0.0698254 0.268972 0.0146439 -0.404245 -0.179855 9.70789 -0.595481 0.348999 59.3503 42.9594 0.132612 5.34247 76.1004 0.909094 13.7618 11.8547 0.833924 0.288914 103.863 0.114784 0.0 84.6794 21.7331 0.657386 17.8614 0.0489419 24.3223 61.1869 17.3493 25.5501782186 26.2747314648 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00738 -1.0 -1 0.5823 0.075071 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 24.9831982417 284.7012087 -1 -1 0.0689165466116 -1.0 -1 AAT /Spectra/Final/AAT/OBrother2016_1_MG.mz -- 284.0 AAT
1237668367458828395 233.974461564 16.0388317753 3 GALAXY 246359593193820 0 0 0 268435456 0 14.1307 14.9373 14.9006 14.4775 14.0798 0.0119689 0.00876201 0.0124211 0.014706 0.0376353 0.0119689 0.00876201 0.0124211 0.014706 0.0376353 0.223411 0.164383 0.119225 0.0904044 0.0640979 13.9073 14.773 14.7814 14.3871 14.0157 258.349 2.96946 2.97009 2.96977 2.96995 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.6612 2.40626 29.6634 0.615558 29.6696 0.844601 29.6649 1.6888 29.668 2.50049 0.922324 0.913303 0.917522 0.986654 0.866597 14.4743 0.011646 15.1806 0.0086128 14.9006 0.0124211 14.4591 0.0146787 14.269 0.0375081 22.1098 0.321549 22.5744 0.276486 22.0508 0.561591 21.2642 0.532048 20.6056 0.397043 20.9935 0.139996 21.9106 0.191334 21.3841 0.344775 20.6423 0.336161 19.9986 0.240041 0.0630882 0.0 0.0 0.0 0.0 0.00738065 0.00396018 -0.0300185 -0.0216639 -0.0278787 0.00168945 -0.0347742 0.068401 0.0201124 -0.00807746 0.426734 59.3275 195.656 0.532309 59.339 196.753 0.813065 59.3449 22.6333 0.831812 59.3327 184.549 0.604563 59.336 196.622 22.0571 0.377674 14.9006 0.0124211 4.00977 5.60323 19.7337 25.7629819145 24.7447206488 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00016 -1.0 -1 0.115635 0.024783 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 35.3227537443 287.903775199 -1 -1 0.169257745098 -1.0 -1 AAT /Spectra/Final/AAT/Gilgamesh2016_1_MG.mz -- 115.0 AAT
1237678881574814449 39.5740150838 -1.3493833882 3 GALAXY 68988044032 1 0 0 268435456 0 20.8693 17.353 17.1039 19.5849 19.4264 3.24967 0.0531143 0.0768591 1.20827 3.7658 3.24967 0.0531143 0.0768591 1.20827 3.7658 0.159765 0.117554 0.0852598 0.0646499 0.0458376 20.7095 17.2354 17.0186 19.5202 19.3806 106.765 2.97021 106.748 1.89058 2.94955 -1000.0 -1000.0 -1000.0 0.248242 0.980372 10.0558 64.2043 19.0334 5.73575 29.6803 1.54114 1.28254 0.803606 1.38133 1.27156 0.997767 0.999732 0.980931 0.173019 0.05 20.696 2.08386 17.1865 0.0528542 17.4638 0.0852813 20.511 0.0922846 20.0304 0.201246 24.5074 1.06983 23.1409 0.192693 21.8712 0.109353 21.2044 0.0916645 20.6353 0.191687 24.8251 1.06136 23.3281 0.255438 21.9467 0.13743 21.255 0.119478 20.8742 0.289246 0.0 0.0223779 0.445076 1.0 1.0 -0.619692 0.00169951 -0.19956 0.00107708 -0.148949 -0.00661269 -0.0258697 -0.033625 0.0304071 -0.0240727 0.231359 59.3686 -1.39267 0.610742 59.3511 73.4515 0.549983 53.7174 53.6023 0.300266 0.986955 33.7534 0.05 50.7165 86.1502 22.5322 0.156461 17.1039 0.0768591 34.3275 56.9651 17.3086 27.7499539971 26.9822771496 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.59201 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 2.40288517604 25.9702640708 -1 -1 0.0140907956488 -1.0 -1 AAT /Spectra/Final/AAT/Narnia2016_1_MG.mz 2 148.0 AAT
1237648704056918638 221.504039494 -0.240567589235 3 GALAXY 52845546177296 1 0 0 268435456 0 17.6229 17.9041 16.9649 16.7331 17.2325 0.163118 0.102859 0.0682047 0.0803632 0.519515 0.163118 0.102859 0.0682047 0.0803632 0.519515 0.21132 0.155487 0.112772 0.085512 0.060629 17.4116 17.7486 16.8522 16.6476 17.1718 258.367 2.96972 258.37 3.315 0.818134 -1000.0 -1000.0 -1000.0 0.136382 0.135854 29.6705 2.45135 29.6639 11.0734 29.6672 3.12762 0.253269 0.131049 0.000135556 0.138849 0.42502 0.538709 0.601598 0.210616 0.222345 18.3199 0.191815 18.3312 0.109262 17.5832 0.0840231 17.9403 0.133691 19.8555 1.03577 24.7223 0.678476 23.2743 0.182587 22.0581 0.0880563 21.2764 0.0639696 20.5631 0.132877 24.1202 0.748857 23.3323 0.249324 22.2868 0.148185 21.4401 0.0722155 20.9861 0.274114 0.0 0.335081 0.552047 0.676015 0.938015 -51.7121 2.83305 2.92532 0.00587911 2.5891 0.0107362 10.8195 -0.00207877 -13.9271 1.68444 0.291872 59.3439 161.148 0.518622 59.3342 155.247 0.79165 55.532 36.0415 0.643251 59.3263 179.371 0.359643 59.3151 146.242 22.7956 0.156746 16.9649 0.0682047 157.653 239.997 14.9245 27.6831136478 27.9084416751 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.07363 -1.0 -1 0.303188 0.0506 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 2.73070320809 20.1702445683 -1 -1 0.0629745892991 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 264.0 AAT
1237666408439874076 354.149256048 0.327135654889 3 GALAXY 439873639153920 0 0 0 268435456 281474976710656 19.0084 17.5877 17.7556 17.5112 16.6073 0.65821 0.0625852 0.11989 0.135155 0.255732 0.65821 0.0625852 0.11989 0.135155 0.255732 0.180303 0.132665 0.0962197 0.0729605 0.0517299 18.8281 17.455 17.6594 17.4382 16.5556 2.96983 258.43 106.721 106.738 106.729 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.6688 4.67312 29.672 5.5689 15.9071 7.38759 29.6752 2.66867 29.6683 6.69654 0.786653 0.680324 0.410557 0.541301 0.649836 19.3437 0.585916 18.0701 0.0766224 19.0124 0.169918 18.396 0.122199 17.4474 0.261338 24.3827 0.969478 22.8847 0.13416 22.4667 0.220019 22.8181 0.23614 21.9866 0.442717 24.0097 1.10144 22.7494 0.159364 22.3338 0.169423 21.9554 0.180316 21.6412 0.54159 0.0 0.599746 0.827468 0.872827 0.797219 -0.749816 -0.0140499 -0.297813 0.00354002 -0.42878 -0.00197215 2.7778 -0.142986 -1.03864 0.0148926 0.151253 59.3337 118.995 0.515816 59.3542 130.038 0.392589 59.3437 119.972 0.197627 55.2108 143.544 0.195292 59.3329 166.745 22.9446 0.212571 17.7556 0.11989 41.9779 61.174 17.7052 28.6179477918 27.8157263213 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.36423 -1.0 -1 0.440122 0.180171 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 2.10045371865 21.2427834111 -1 -1 0.271041570532 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz -- 257.0 AAT
1237666408439874076 354.149256048 0.327135654889 3 GALAXY 439873639153920 0 0 0 268435456 281474976710656 19.0084 17.5877 17.7556 17.5112 16.6073 0.65821 0.0625852 0.11989 0.135155 0.255732 0.65821 0.0625852 0.11989 0.135155 0.255732 0.180303 0.132665 0.0962197 0.0729605 0.0517299 18.8281 17.455 17.6594 17.4382 16.5556 2.96983 258.43 106.721 106.738 106.729 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.6688 4.67312 29.672 5.5689 15.9071 7.38759 29.6752 2.66867 29.6683 6.69654 0.786653 0.680324 0.410557 0.541301 0.649836 19.3437 0.585916 18.0701 0.0766224 19.0124 0.169918 18.396 0.122199 17.4474 0.261338 24.3827 0.969478 22.8847 0.13416 22.4667 0.220019 22.8181 0.23614 21.9866 0.442717 24.0097 1.10144 22.7494 0.159364 22.3338 0.169423 21.9554 0.180316 21.6412 0.54159 0.0 0.599746 0.827468 0.872827 0.797219 -0.749816 -0.0140499 -0.297813 0.00354002 -0.42878 -0.00197215 2.7778 -0.142986 -1.03864 0.0148926 0.151253 59.3337 118.995 0.515816 59.3542 130.038 0.392589 59.3437 119.972 0.197627 55.2108 143.544 0.195292 59.3329 166.745 22.9446 0.212571 17.7556 0.11989 41.9779 61.174 17.7052 28.6179477918 27.8157263213 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.36423 -1.0 -1 0.440122 0.180171 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 2.10045371865 21.2427834111 -1 -1 0.271041570532 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz -- 257.0 AAT
1237657607497319275 123.268135605 36.2440139751 3 GALAXY 68987912448 1 0 0 268435456 0 18.2168 18.2691 17.1063 16.4787 16.09 0.259743 0.127589 0.0671022 0.0507431 0.136208 0.259743 0.127589 0.0671022 0.0507431 0.136208 0.353994 0.260465 0.188911 0.143246 0.101563 17.8628 18.0086 16.9174 16.3355 15.9884 1.04971 2.97081 2.97014 2.22609 2.9702 0.132542 -1000.0 -1000.0 0.101043 -1000.0 0.794462 1.47012 29.6797 3.40946 29.668 9.28566 25.1167 5.23712 29.6737 3.43809 0.05 0.720005 0.897121 0.999664 0.838402 22.385 0.275027 19.9034 0.15927 17.4533 0.0747911 18.4146 0.0765363 17.5311 0.157976 22.502 0.244602 22.9981 0.169738 22.3214 0.143097 21.5908 0.0821038 21.37 0.248172 22.9068 0.389042 23.1127 0.217517 22.3712 0.16871 21.4085 0.0964894 20.9697 0.238479 0.523537 0.602172 0.408085 0.498072 0.641105 -0.0786209 -0.241685 -0.072131 0.0742269 0.0232091 -0.0397222 -0.0105172 0.123846 0.201042 -0.0990881 0.05 0.192508 -2.79607 0.78835 1.89472 20.5028 0.466748 59.3487 30.6689 0.76682 1.02198 0.922928 0.378496 4.17523 97.6086 22.9764 0.192895 17.1063 0.0671022 3.41266 5.47938 20.766 27.9687904535 25.4269557478 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.705065 0.000219445 4 0.134896 0.064958 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 1.45857268371 16.0114959301 -1 -1 0.0617401207529 -1.0 -1 SDSS SDSS -- SDSS
1237648704057050440 221.89003593 -0.250720211145 3 GALAXY 281543964754176 1 0 0 268435456 281474976710656 17.4201 18.082 17.4835 28.9864 28.1395 0.122263 0.110969 0.098641 1.19192 0.636406 0.122263 0.110969 0.098641 1.19192 0.636406 0.231993 0.170699 0.123805 0.0938774 0.0665603 17.1881 17.9113 17.3597 28.8925 28.073 2.9696 2.96936 68.2773 1.07304 0.929243 -1000.0 -1000.0 -1000.0 0.227757 0.147784 29.6686 2.47339 27.5249 16.8701 29.6596 2.31845 0.00125587 1.47615 0.225599 2.19508 0.559254 0.999723 0.887207 0.0552194 0.0990718 17.851 0.134328 17.8414 0.109251 18.0062 0.114047 22.0233 0.130206 21.2867 0.265465 23.7277 0.411285 23.5328 0.205488 22.5042 0.131058 21.9975 0.121189 21.4401 0.25009 24.0605 0.392863 23.7383 0.337665 22.5447 0.186456 22.4629 0.253884 21.8154 0.511801 0.0 0.0 0.557617 1.0 1.0 -3.46507 0.0418849 -0.0928087 0.00453229 -0.0576587 0.0107331 0.279076 -0.00296923 0.287712 0.0476231 0.324976 59.3378 124.533 0.843122 59.3239 163.471 0.653365 55.7332 3.03069 0.0760545 0.000546484 0.025026 0.097268 0.378867 146.784 23.1019 0.203107 17.4835 0.098641 29.23 41.6002 18.204 28.2094778544 27.5285801268 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 -0.00052 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 20.7091567454 152.966559188 -1 -1 0.0598754690909 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 4.0 AAT
1237679996084618235 335.944149612 -3.42971396292 3 GALAXY 422281453110016 1 0 0 268435456 281474976710656 19.6617 18.7984 17.8892 18.2751 27.0803 0.803183 0.15 0.103178 0.232389 1.22739 0.803183 0.15 0.103178 0.232389 1.22739 0.326095 0.239937 0.174023 0.131956 0.0935585 19.3356 18.5584 17.7152 18.1432 26.9868 106.72 2.96947 106.727 1.77452 0.769548 -1000.0 -1000.0 -1000.0 0.827213 0.349529 10.1676 14.2086 29.6611 14.0226 29.6688 4.33029 4.26997 2.86454 0.00388309 12.8824 0.05 0.05 0.36054 0.05 0.153286 21.1725 0.425337 21.2804 0.28978 18.3673 0.11821 21.2924 0.202941 21.9852 0.537469 23.189 0.55587 24.0625 0.410854 22.6889 0.173071 22.4104 0.211984 22.0028 0.521644 22.9765 0.613796 24.1745 0.520276 22.6257 0.230246 22.5804 0.349771 22.2132 0.774198 0.953862 0.0 0.531835 0.534782 1.0 -1.08025 0.394262 2.1283 -0.00546058 1.27349 -0.00447342 1.00522 0.0210215 -6.71564 0.00771856 0.137168 25.974 127.155 0.05 19.7791 90.87 0.23433 59.3476 167.943 0.05 2.19525 75.0317 0.0935701 0.00299789 66.8017 23.2302 0.259296 17.8892 0.103178 36.189 54.5524 17.9503 28.7516599284 27.7385973506 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.23193 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 335.913 -3.43167 39.1759 2828.0 -23.8340949122 149781 0 OBrother 1.86931518968 21.3023547728 -1 -1 0.140434915711 -1.0 -1 AAT /Spectra/Final/AAT/OBrother_1_MG.mz -- 319.0 AAT
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1237662698115237198 247.644214855 19.9588877603 3 GALAXY 281543964623104 1 0 0 268435456 281474976710656 29.5592 19.4326 18.0202 18.1677 18.687 0.727629 0.256526 0.105169 0.19081 1.08119 0.727629 0.256526 0.105169 0.19081 1.08119 0.301252 0.221658 0.160765 0.121903 0.0864309 29.2579 19.2109 17.8595 18.0458 18.6006 2.96985 2.96992 68.3184 1.40406 2.97063 -1000.0 -1000.0 -1000.0 0.427057 -1000.0 20.5417 49.5809 1.70815 1.60173 29.6776 2.43735 1.43811 1.17967 23.7816 8.7603 0.99966 0.05 0.454815 0.0558665 0.05 28.8244 0.616396 23.0591 0.233919 18.4891 0.120731 21.95 0.180517 19.5513 0.605208 25.2149 0.548472 23.7455 0.234155 23.0507 0.173982 22.6574 0.180495 22.5869 0.407538 24.5077 0.882473 23.6922 0.323742 22.7909 0.217689 22.6537 0.297644 22.6971 0.629931 0.0 0.445207 0.516113 0.533171 0.591065 -3.30906 0.273711 -3.36026 -0.0293676 5.22457 0.0490649 -5.26914 -0.0991799 -0.582674 0.0664846 0.608205 17.6019 114.08 0.05 1.21676 65.4806 0.472646 47.0862 203.768 0.3057 0.732101 84.6894 0.100002 30.7153 182.331 23.3543 0.234656 18.0206 0.105169 20.7253 38.5525 18.537 28.380543459 27.1150032123 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.0903 -1.0 -1 0.094972 0.067909 -1.0 -1.0 -1.0 -1.0 248.087 19.8264 34.3199 2375.0 -24.0277300687 147100 0 Odyssey 26.2161264974 261.719719068 -1 -1 0.00226478342688 -1.0 -1 AAT /Spectra/Final/AAT/Odyssey_1_MG.mz -- 220.0 AAT
1237648704056919077 221.491946199 -0.246978545646 3 GALAXY 281543964623616 1 0 0 268435456 281474976710656 18.0713 19.0798 18.0044 18.0808 18.108 0.175837 0.216441 0.12516 0.200094 0.853003 0.175837 0.216441 0.12516 0.200094 0.853003 0.205849 0.151462 0.109853 0.0832978 0.0590592 17.8654 18.9284 17.8945 17.9975 18.0489 2.96973 258.366 258.37 1.87237 3.01659 -1000.0 -1000.0 -1000.0 0.694763 2.87304 29.6659 6.23406 29.6665 6.80338 29.6673 41.958 6.62436 4.32084 16.2828 17.9476 0.387208 0.585058 0.05 0.152501 0.199993 19.4388 0.2649 19.9492 0.214401 19.541 0.190804 20.3204 0.28509 18.8983 0.265153 23.8312 0.53877 23.9275 0.296421 22.8458 0.172082 22.4827 0.174125 21.6393 0.3101 24.6218 0.828583 23.8286 0.359645 22.8032 0.232691 22.4056 0.241366 21.4107 0.379432 0.0 0.917707 0.886661 0.941867 1.0 128.762 43.7553 12.8221 -0.304422 -13.3646 -0.0654855 25.3719 1.77441 -34.1503 62.4247 0.05 59.3299 61.0809 0.550986 46.4905 138.051 0.352816 59.3293 39.4242 0.219714 52.6829 48.1912 0.249951 8.98258 34.9879 23.3717 0.251356 18.0044 0.12516 200.822 251.364 14.9041 28.8661916699 28.4135712375 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.16977 -1.0 -1 0.234543 0.103909 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 3.54940435518 26.2175503044 -1 -1 0.0581705793379 -1.0 -1 AAT /Spectra/Final/AAT/Dune2016_1_MG.mz -- 165.0 AAT
1237648704056918832 221.581274221 -0.224492464984 3 GALAXY 387099228504848 0 0 0 268435456 281474976710656 18.4297 18.206 17.1074 16.6178 16.0783 0.278102 0.113389 0.0647157 0.0609433 0.153021 0.278102 0.113389 0.0647157 0.0609433 0.153021 0.222998 0.16408 0.119004 0.0902373 0.0639794 18.2067 18.0419 16.9884 16.5276 16.0144 2.18936 2.96972 2.96977 258.294 3.25438 2.06922 -1000.0 -1000.0 -1000.0 1.98869 29.6648 10.6121 20.966 12.1504 29.6695 1.76307 29.6574 3.87525 29.6693 3.4106 0.0809721 0.999728 0.551552 0.456388 0.728767 19.7148 0.232711 17.7264 0.10602 16.888 0.0616732 17.0139 0.0708338 16.2571 0.182269 23.1376 0.339764 25.0265 0.404619 24.701 0.706096 22.3551 0.184042 21.2064 0.217905 23.16 0.412906 23.9214 0.425384 22.8081 0.322507 21.7385 0.144564 21.0519 0.28513 0.455401 0.0 0.0 0.379104 0.483046 -50.4748 -5.84197 -0.201059 -0.0378848 7.02387 0.00520245 -1.29418 0.00387309 2.54708 0.0410603 0.05 47.6297 37.4765 0.914249 59.3393 84.2889 0.634261 59.3349 26.0442 0.480676 59.3197 57.7643 0.778768 59.3284 134.655 23.4381 0.364775 16.888 0.0616732 172.604 243.56 14.905 27.7499738756 28.0857491071 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.807516 -1.0 -1 0.208863 0.098833 -1.0 -1.0 -1.0 -1.0 221.546 -0.222942 25.3928 1659.36 -23.5995529604 165536 0 Dune 2.11848063446 15.6480844102 -1 -1 0.0719680357765 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0418_4.zlog -- 46.0 MMT
1237663784194802917 354.082573493 0.0606011959357 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 18.9742 18.065 17.821 17.0293 17.6484 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.177183 0.130369 0.0945548 0.0716981 0.0508348 18.797 17.9346 17.7265 16.9576 17.5975 166.532 166.519 2.13242 166.521 1.51506 -1000.0 -1000.0 1.98958 -1000.0 1.3726 27.7313 38.3936 29.67 3.6178 29.6636 3.84095 29.6681 4.98251 3.15931 6.56673 0.05 0.416075 0.439032 0.537075 0.0999623 20.4846 0.326491 18.4098 0.107972 18.0634 0.152897 17.5438 0.105611 20.6131 0.349476 23.6721 0.458279 23.5247 0.199858 23.9531 0.372164 22.4871 0.167451 21.7329 0.33456 23.315 0.523709 23.1555 0.22177 22.8352 0.273454 22.0672 0.200834 21.6757 0.539247 0.832777 0.363506 0.405709 0.523537 0.674803 -0.327571 0.0052023 0.728635 -0.0113849 -28.5556 -0.347043 0.652797 -0.000978889 -0.232232 -0.00282717 0.100326 30.6986 96.288 0.397939 59.3397 120.465 0.539669 59.3212 134.438 0.398894 59.3404 132.211 0.226735 0.967878 179.969 23.4733 0.310638 17.6338 0.130805 71.4389 108.246 16.9051 28.4953306615 28.1701969783 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.18022 -1.0 -1 0.019204 0.096566 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 14.4940499323 146.584077384 -1 -1 0.167829510881 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz 2 142.0 AAT
1237663784194802917 354.082573493 0.0606011959357 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 18.9742 18.065 17.821 17.0293 17.6484 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.468443 0.0962061 0.126755 0.0898189 0.658856 0.177183 0.130369 0.0945548 0.0716981 0.0508348 18.797 17.9346 17.7265 16.9576 17.5975 166.532 166.519 2.13242 166.521 1.51506 -1000.0 -1000.0 1.98958 -1000.0 1.3726 27.7313 38.3936 29.67 3.6178 29.6636 3.84095 29.6681 4.98251 3.15931 6.56673 0.05 0.416075 0.439032 0.537075 0.0999623 20.4846 0.326491 18.4098 0.107972 18.0634 0.152897 17.5438 0.105611 20.6131 0.349476 23.6721 0.458279 23.5247 0.199858 23.9531 0.372164 22.4871 0.167451 21.7329 0.33456 23.315 0.523709 23.1555 0.22177 22.8352 0.273454 22.0672 0.200834 21.6757 0.539247 0.832777 0.363506 0.405709 0.523537 0.674803 -0.327571 0.0052023 0.728635 -0.0113849 -28.5556 -0.347043 0.652797 -0.000978889 -0.232232 -0.00282717 0.100326 30.6986 96.288 0.397939 59.3397 120.465 0.539669 59.3212 134.438 0.398894 59.3404 132.211 0.226735 0.967878 179.969 23.4733 0.310638 17.6338 0.130805 71.4389 108.246 16.9051 28.4953306615 28.1701969783 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.18022 -1.0 -1 0.019204 0.096566 -1.0 -1.0 -1.0 -1.0 354.131 0.297265 34.7674 2556.76 -23.4058610709 61945 0 AnaK 14.4940499323 146.584077384 -1 -1 0.167829510881 -1.0 -1 AAT /Spectra/Final/AAT/AnaK2016_1_MG.mz 2 142.0 AAT
1237665565541532709 233.633959197 16.5561911883 3 GALAXY 281543964623104 1 0 0 268435456 281474976710656 30.1548 18.7602 17.6191 30.979 26.1373 0.62063 0.175002 0.0913872 0.16361 3.13015 0.62063 0.175002 0.0913872 0.16361 3.13015 0.244073 0.179587 0.130251 0.0987656 0.070026 29.9108 18.5806 17.4889 30.8802 26.0673 1.05309 2.96962 166.505 1.32637 0.400079 0.184536 -1000.0 -1000.0 0.635396 0.201958 0.0379934 3.11811 1.91712 2.11928 29.6676 3.37322 9.76926e-05 0.0995631 2.66652 5.82762 0.38703 0.05 0.767958 0.300671 0.05 23.0117 0.411277 22.8207 0.200153 17.8609 0.0997316 22.7108 0.234739 21.2883 0.588567 22.9025 0.357298 23.5567 0.215202 22.9972 0.185936 22.6789 0.213596 21.9968 0.384552 23.7316 0.744245 23.4126 0.245255 22.953 0.240633 23.0771 0.396498 22.2207 0.560044 1.0 0.277219 0.273212 1.0 1.0 -0.328216 -0.000220789 12.1773 0.266048 -0.376728 -0.00928377 -0.111605 -0.00113004 -0.325734 -0.000475736 0.389742 0.0401338 59.1162 0.05 1.22587 141.872 0.481118 59.331 128.282 0.400101 0.00027231 130.834 0.451339 0.0826133 60.1252 23.4781 0.248478 17.6191 0.0913872 55.929 96.536 17.2126 28.4809685854 27.9462444798 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00941 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 28.8066095548 234.794279549 -1 -1 0.00941415289189 -1.0 -1 AAT /Spectra/Final/AAT/Gilgamesh2016_1_MG.mz -- 186.0 AAT
1237657594075873891 123.485301366 36.1920509675 3 GALAXY 281573022892360 0 0 0 268435456 281474976710656 20.646 18.0466 18.0624 17.2057 18.2345 1.62524 0.0693096 0.112594 0.0806454 0.759757 1.62524 0.0693096 0.112594 0.0806454 0.759757 0.349009 0.256797 0.186251 0.141228 0.100133 20.297 17.7898 17.8762 17.0644 18.1344 2.97001 2.97034 2.9702 106.735 2.9699 -1000.0 -1000.0 -1000.0 -1000.0 -1000.0 29.5063 67.3726 29.6697 9.43842 29.6679 16.7113 29.6728 2.86907 5.70006 16.009 0.05 0.945779 0.994325 0.895638 0.05 19.6517 0.632895 17.6949 0.0643936 17.8936 0.115951 17.3413 0.0842618 20.863 0.520587 24.8778 0.634079 23.2832 0.151601 23.4143 0.273336 22.8637 0.254549 22.3036 0.38162 24.3642 0.899972 23.0764 0.20065 22.9534 0.282362 22.4896 0.287537 22.0307 0.577743 0.0 0.159653 0.498361 0.216888 0.469988 83.763 -27.2728 5.3747 0.244216 0.0700574 -0.0374293 3.40751 0.465809 -36.7632 7.9453 0.19999 57.2475 -3.77538 0.343645 59.3515 77.5204 0.538358 54.1492 33.7728 0.197327 59.3413 52.662 0.05 2.73835 9.39628 23.5697 0.31158 17.453 0.102445 30.5953 43.2366 17.7478 28.1164123114 27.1715478383 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.971988 -1.0 -1 0.564412 0.075658 -1.0 -1.0 -1.0 -1.0 123.241 36.2546 37.7379 2469.7 -23.4768886466 33446 0 StarTrek 12.4062186273 136.189095041 -1 -1 0.184927684955 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2016.0206_1.zlog -- 267.0 MMT
1237665565541532705 233.633939264 16.5596769815 3 GALAXY 299136150799104 1 0 0 268435456 281474976710656 30.3721 18.5231 17.4898 30.727 20.059 0.563455 0.159029 0.0924907 0.234499 5.65412 0.563455 0.159029 0.0924907 0.234499 5.65412 0.243451 0.179129 0.129919 0.0985139 0.0698476 30.1287 18.344 17.3599 30.6285 19.9891 106.722 2.96962 106.719 1.77571 1.46417 -1000.0 -1000.0 -1000.0 0.519332 1.28036 0.101044 12.725 0.0400398 3.46039 27.7646 12.0044 0.665951 0.656577 0.195462 0.00122059 0.9995 0.994199 0.999743 0.05 0.0996791 24.7761 0.94493 24.1023 0.334973 17.7663 0.102231 21.6646 0.126231 21.2754 0.325378 24.3852 0.862645 24.0897 0.318194 22.9068 0.172437 22.0396 0.131577 21.3004 0.235428 25.2803 0.842876 24.238 0.451074 22.9698 0.244169 22.258 0.155396 21.7112 0.413606 0.0 0.0 0.300083 1.0 1.0 -0.25982 0.00677203 0.0397382 0.0243384 0.386465 -0.00563123 -0.232083 0.00481512 -0.315776 0.000945577 0.999655 0.149732 146.287 0.998325 0.0396248 105.968 0.615081 59.3304 79.9284 0.05 0.773438 176.135 0.0951001 0.427893 187.451 23.4953 0.251797 17.4898 0.0924907 33.5719 60.8854 17.8606 28.3516501073 27.4859717701 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.006942 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 28.7857610292 234.624353266 -1 -1 0.000477508829719 -1.0 -1 MMT /Spectra/Final/MMT/spHect-2015.0218_1.zlog 2 113.0 MMT
1237678890137617086 39.777894837 -1.55434837171 3 GALAXY 281543964623104 0 0 0 268435456 281474976710656 19.8586 18.4253 17.9279 17.7033 16.084 1.43942 0.158591 0.193611 0.260706 0.204893 1.43942 0.158591 0.193611 0.260706 0.204893 0.165154 0.121519 0.0881357 0.0668306 0.0473837 19.6935 18.3038 17.8398 17.6364 16.0367 1.71794 258.44 258.431 0.851923 2.9705 1.58874 -1000.0 -1000.0 0.43973 -1000.0 2.63225 5.47351 27.8571 19.6265 29.6728 8.74795 7.86942e-05 0.298385 29.6714 20.2509 0.05 0.433778 0.694256 0.363236 0.437898 21.1662 0.869338 19.3242 0.202851 19.6229 0.230792 22.643 0.299502 16.1246 0.25753 22.949 0.364106 22.9782 0.15531 23.1169 0.274358 22.6051 0.276784 22.7807 0.651364 23.0352 0.481413 23.2887 0.247216 22.9869 0.349727 23.0592 0.583592 22.4277 0.850042 0.813747 0.731584 0.645975 0.771205 0.0 -40.6828 -5.89377 6.95072 0.00938994 7.50323 0.0448874 20.9478 0.230167 57.1811 12.8619 0.0999834 56.6866 61.1518 0.65217 56.3096 150.696 0.152866 5.2939 30.4041 0.0512159 0.00984645 80.7317 0.719869 51.7383 161.699 23.5204 0.36134 21.3014 0.227716 -9999.0 -9999.0 33.8672 26.9157771651 55.8624276422 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.02839 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 39.5482 -1.31876 37.155 2629.0 -23.5160863282 132339 0 Narnia 19.7388478272 213.33533565 -1 -1 0.298876430749 -1.0 -1 AAT /Spectra/Final/AAT/Narnia2016_1_MG.mz -- 48.0 AAT
1237665565541532271 233.609145097 16.5288963457 3 GALAXY 316728370401552 1 0 0 268435456 281474976710656 30.5217 19.0758 17.9384 29.4206 27.9334 0.378817 0.200894 0.104389 0.58463 0.513342 0.378817 0.200894 0.104389 0.58463 0.513342 0.248742 0.183022 0.132743 0.100655 0.0713655 30.2729 18.8928 17.8056 29.3199 27.8621 0.0955688 2.96962 166.505 2.97008 2.96992 1.46106 -1000.0 -1000.0 -1000.0 -1000.0 0.0689116 10.1992 0.0919651 0.938451 29.6674 3.42225 29.6683 82.2217 0.0108087 46.6225 0.99951 0.986291 0.366725 0.05 0.176209 24.9465 0.86858 23.101 0.344392 18.3809 0.121813 21.1844 0.546467 22.9776 0.578883 24.688 0.868415 24.3035 0.29005 22.9921 0.185691 24.2825 0.509663 22.8986 0.493692 25.2114 0.870984 23.8175 0.217537 22.9916 0.248614 24.2484 0.699684 22.6558 0.639143 0.0 0.276612 0.437825 1.0 0.0 -0.163542 0.00253754 -0.511515 0.00117754 0.323887 0.0128068 0.185639 -0.000749933 0.318084 0.00325387 0.989424 0.0929819 74.3981 0.153326 3.03824 179.064 0.347406 59.3326 93.679 0.910839 0.0507251 178.16 0.15047 0.0106753 102.402 23.5577 0.263583 17.9384 0.104389 62.6784 97.0861 16.8903 28.8002867269 27.8713402616 9999.0 9999.0 9999.0 9999.0 9999.0 9999.0 0.00076 -1.0 -1 -9999.0 -9999.0 -1.0 -1.0 -1.0 -1.0 234.132 16.6078 28.0204 1967.37 -23.7233716534 166313 0 Gilgamesh 30.439165979 248.100432777 -1 -1 0.0241886934932 -1.0 -1 AAT /Spectra/Final/AAT/Gilgamesh2016_1_MG.mz -- 190.0 AAT



In [29]:

    
newtab = bright_tab['RA', 'DEC']
newtab['RA'].name = 'ra'
newtab['DEC'].name = 'dec'
newtab.add_column(table.Column(name='name', data=np.arange(len(newtab))), 0)

sio = StringIO()
newtab.write(sio, format='ascii')
print(sio.getvalue())
print('Paste the above into http://skyserver.sdss.org/dr13/en/tools/crossid/crossid.aspx')









    



name ra dec
0 354.14926 0.32713565
1 353.99294 0.086364837
2 354.08257 0.060601196
3 247.64421 19.958888
4 335.94415 -3.429714
5 335.97281 -3.4295662
6 335.82694 -3.6492167
7 335.80925 -3.0283747
8 354.14926 0.32713565
9 353.99294 0.086364837
10 354.08257 0.060601196
11 234.33588 16.249183
12 234.33322 16.248215
13 233.63394 16.559677
14 233.63396 16.556191
15 233.60915 16.528896
16 233.97446 16.038832
17 123.26675 36.256392
18 122.98465 35.86291
19 123.26544 36.232026
20 123.26814 36.244014
21 123.4853 36.192051
22 221.50404 -0.24056759
23 221.58943 -0.24814454
24 221.51179 -0.21110648
25 221.58127 -0.22449246
26 221.49195 -0.24697855
27 221.89004 -0.25072021
28 39.574015 -1.3493834
29 39.777895 -1.5543484

Paste the above into http://skyserver.sdss.org/dr13/en/tools/crossid/crossid.aspx

OBJID	RA	DEC	PHOTPTYPE	PHOT_SG	FLAGS	clean	SATURATED	BAD_COUNTS_ERROR	BINNED1	TOO_FEW_GOOD_DETECTIONS	u	g	r	i	z	u_err	g_err	r_err	i_err	z_err	MODELMAGERR_U	MODELMAGERR_G	MODELMAGERR_R	MODELMAGERR_I	MODELMAGERR_Z	EXTINCTION_U	EXTINCTION_G	EXTINCTION_R	EXTINCTION_I	EXTINCTION_Z	DERED_U	DERED_G	DERED_R	DERED_I	DERED_Z	PETRORAD_U	PETRORAD_G	PETRORAD_R	PETRORAD_I	PETRORAD_Z	PETRORADERR_U	PETRORADERR_G	PETRORADERR_R	PETRORADERR_I	PETRORADERR_Z	DEVRAD_U	DEVRADERR_U	DEVRAD_G	DEVRADERR_G	DEVRAD_R	DEVRADERR_R	DEVRAD_I	DEVRADERR_I	DEVRAD_Z	DEVRADERR_Z	DEVAB_U	DEVAB_G	DEVAB_R	DEVAB_I	DEVAB_Z	CMODELMAG_U	CMODELMAGERR_U	CMODELMAG_G	CMODELMAGERR_G	CMODELMAG_R	CMODELMAGERR_R	CMODELMAG_I	CMODELMAGERR_I	CMODELMAG_Z	CMODELMAGERR_Z	PSFMAG_U	PSFMAGERR_U	PSFMAG_G	PSFMAGERR_G	PSFMAG_R	PSFMAGERR_R	PSFMAG_I	PSFMAGERR_I	PSFMAG_Z	PSFMAGERR_Z	FIBERMAG_U	FIBERMAGERR_U	FIBERMAG_G	FIBERMAGERR_G	FIBERMAG_R	FIBERMAGERR_R	FIBERMAG_I	FIBERMAGERR_I	FIBERMAG_Z	FIBERMAGERR_Z	FRACDEV_U	FRACDEV_G	FRACDEV_R	FRACDEV_I	FRACDEV_Z	Q_U	U_U	Q_G	U_G	Q_R	U_R	Q_I	U_I	Q_Z	U_Z	EXPAB_U	EXPRAD_U	EXPPHI_U	EXPAB_G	EXPRAD_G	EXPPHI_G	EXPAB_R	EXPRAD_R	EXPPHI_R	EXPAB_I	EXPRAD_I	EXPPHI_I	EXPAB_Z	EXPRAD_Z	EXPPHI_Z	FIBER2MAG_R	FIBER2MAGERR_R	EXPMAG_R	EXPMAGERR_R	PETROR50_R	PETROR90_R	PETROMAG_R	SB_EXP_R	SB_PETRO_R	J	JERR	H	HERR	K	KERR	SPEC_Z	SPEC_Z_ERR	SPEC_Z_WARN	PHOTOZ	PHOTOZ_ERR	W1	W1ERR	W2	W2ERR	HOST_RA	HOST_DEC	HOST_DIST	HOST_VHOST	HOST_MK	HOST_NSAID	HOST_FLAG	HOST_SAGA_NAME	RHOST_ARCM	RHOST_KPC	OBJ_NSAID	SATS	PROBABILITY_CLASS1	RESCALED_PROBABILITY_CLASS1	REMOVE	TELNAME	MASKNAME	ZQUALITY	SPEC_CLASS	SPECOBJID	SPEC_REPEAT
int64	float64	float64	int16	str40	int64	int32	int64	int64	int64	int64	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float32	float64	float64	float32	float32	float32	float32	float32	float32	float32	float32	int32	float32	float32	float64	float64	float64	float64	float64	float64	float64	float64	float64	int64	int64	str48	float64	float64	int64	int64	float64	float64	int64	str6	str48	int64	str2	str48	str48
1237667228223471668	34.4564849708	6.29468048722	3	GALAXY	35255541174616	0	0	0	268435456	0	15.9043	15.4342	15.3632	15.0431	-99.0	0.0503136	0.0143256	0.0343602	0.139791	0.0875026	0.154576	0.0338745	0.0601029	0.215043	1.10988	0.333093	0.245087	0.177757	0.134788	0.0955664	21.2894	20.5442	20.7151	21.7277	22.8531	1.47284	3.07161	1.65845	1.59846	2.97041	1.3414	0.160255	0.108122	0.382837	-1000.0	0.380657	0.929018	2.27832	0.385527	0.738574	0.333412	0.655921	2.092	0.283904	70.0553	0.0999995	0.699636	0.713542	0.05	0.229759	21.7672	0.392808	20.2781	0.0388224	20.8928	0.0920885	21.983	0.450744	22.99	4.15853	21.9654	0.170399	21.4341	0.0466062	21.4402	0.0791677	22.4143	0.223826	23.1191	0.683259	21.6331	0.141289	21.1902	0.0424327	21.1542	0.0693863	21.7453	0.201541	22.0091	4.68785	0.0	0.22388	0.0	0.876136	0.0	0.0625673	-0.065178	-0.0211262	0.0176206	0.0142408	-0.00128577	0.139752	0.0723178	0.690597	3.04668	0.296689	0.523009	145.3	0.746344	1.41153	96.5558	0.779925	0.69977	142.691	0.05	0.591346	19.6805	0.673114	0.31652	44.3738	21.8465	0.0878419	20.8928	0.0920885	0.934878	1.49912	21.0499	22.1130530087	22.8991184069	9999.0	9999.0	9999.0	9999.0	9999.0	9999.0	0.00519694	-1.0	0	-9999.0	-9999.0	-1.0	-1.0	-1.0	-1.0	33.8651	6.00248	20.6466	1562.0	-23.06324272	131531	0		39.3874952535	236.550310958	131609	1	0.435620214674	-1.0	-1	NSA	ned	4		1.23766722822e+18	NSA
1237664337178788133	175.563531091	36.2980602831	3	GALAXY	105622137733208	0	0	0	268435456	0	18.3103	17.3519	17.0066	16.6657	16.6971	0.076692	0.0106417	0.0178551	0.0199619	0.0548733	0.216618	0.118535	0.180281	0.197141	0.723844	0.0943027	0.069387	0.0503252	0.0381601	0.027056	22.1403	22.3718	22.2103	21.9348	22.7755	1.55861	1.52655	1.55302	1.5262	0.674857	0.304761	0.217325	0.295551	0.327641	0.238354	0.287834	1.61724	0.294085	0.519152	0.236273	1.45102	0.31401	1.79268	0.0427931	220.845	0.05	0.206997	0.681292	0.288203	0.578539	22.2458	0.4058	22.4468	0.257024	22.2606	0.722022	21.9787	0.718815	22.8177	5.183	22.2886	0.22739	22.5932	0.164694	22.3974	0.232496	22.152	0.23899	22.8304	0.836933	21.9774	0.188703	21.5898	0.0747299	21.2777	0.0860818	21.2412	0.122903	20.9491	0.39159	1.0	0.0	0.0	0.0	0.0	0.0407523	0.111773	-0.0681097	-0.00436986	0.0243384	-0.0217834	0.0793985	-0.106561	-0.145641	0.119391	0.0608827	0.413605	129.204	0.270238	0.453254	96.0956	0.749857	0.379026	159.104	0.323366	0.458423	149.353	0.746803	0.0436463	6.83858	22.1127	0.123281	22.2606	0.722022	0.811281	1.31041	22.47	22.1494026185	24.011259801	9999.0	9999.0	9999.0	9999.0	9999.0	9999.0	0.00470981	-1.0	0	-1.0	-1.0	-1.0	-1.0	-1.0	-1.0	175.328	36.5468	24.6947	1465.0	-23.1060187728	140065	0		18.746034364	134.659540527	89238	1	-1.0	-1.0	-1	NSA	sdss	4		1.23766433718e+18	NSA